postgresql basics

\?
\l - show databases
\dt - show tables
\conninfo
\d+ tablename - describe table
\i filename - execute file
pg_dump -s database - dump db schema
pg_dump database - dump db schema + data
pg_dump -s database -t tablename - dump single table schema