Useful psql commands

Formatting
  \x [on|off]            toggle expanded output (currently off)  
  \a                     toggle between CSV and table output

Informational
  \l[+]                  list all databases
  \dp     [PATTERN]      list table, view, and sequence access privileges
  \dt[S+] [PATTERN]      list tables