create-database

Create Database

Enter in psql

sudo -u postgres psql

Exit from psql terminal

\q

See User list

\du

Note: This command will return list of the users.

Create User with password

CREATE USER username WITH PASSWORD 'YourPassword';

Note: Replace username with your database user, and password with your password.

See Database list

\l

Note: This command will return the list of databases.

Create Database with giving ownership to User

CREATE DATABASE db_name OWNER username;

Note: Replace db_name with your project database name and username with your dabatase user.

Grant previleges on database

GRANT ALL PRIVILEGES ON DATABASE db_name TO username;

Note: Replace db_name with your project database name and username with your database user.

Give ownership to a database user

ALTER DATABASE db_name OWNER TO username;

Connect to database

\c database_name;

Note: This will enter in your database;

See tables list

\dt

Note: This command will return the list of table under the database.