Connecting: psql -U <username> -h <host> -d <database>
- connect to database
\c database
- create database
create database <name>
- drop database
drop database <name
- list databases
\l
- list roles
\du
- list tables
\dt
- list columns
\d <table>
- help
\?
- quit
\q
- backup database `pg_dump >