\? - help
\l - list databases
\c <db name> - to connect to a database
\d - to list tables
Create database
CREATE DATABASE <DB_NAME>;
CREATE USER <DB_USER> WITH PASSWORD '<PASSWORD>';
GRANT ALL PRIVILEGES ON DATABASE "<DB_NAME>" TO "<DB_USER>";
Backups and Restoring
pg_dump -U <DB_USER> -Fp <DB_NAME> > <DB_DUMP_FILENAME>
psql -U <DB_USER> -d <DB_NAME> -f <DB_DUMP_FILENAME>