PostgreSQL Cheat-Sheet
Connect to PostgreSQL
psql -U postgres
Connect to PostgreSQL as the postgres user
psql -U <user> -d <database>
Connect to PostgreSQL as a specific user and database
psql -U <user> -d <database> -h <host>
Connect to PostgreSQL on a specific host
PostreSQL CLI Commands
\c <database>
Connect to a specific database
\password <user>
Change password for a specific user
\l
List all databases
\d+
Show detailed information about various database objects
\dt
List all tables in the current database
\du
List all users
\df
List all functions
\dv
List all views
\dn
List all schemas
\dp
List all permissions
\di
List all indexes
\ds
List all sequences
\d+
Show detailed information about various database objects
\q
Quit psql
\x
Toggle expanded output
Backup and Restore
pg_dump <database> > backup.sql
Backup a database to a file
psql <database> < backup.sql
Restore a database from a file