A few reminders for myself when using Postgres.
desribe tablename:
\\d+ tablename
show tables:
select tablename from pg_tables;
(also shows many tables relating to postgres structural stuff).
show databases:
select datname from pg_database;
use databasename:
\\c databasename
auto_increment:
Define column type as SERIAL.