postgres_commands.md

###postgres commands

• list databases: \list or \l
• create database:create database <dbName>;
• create user: create user <userName> with password 'password';
• list user: \du
• set privilages: GRANT ALL PRIVILAGES ON DATABASE <dbName> TO user;