PostgreSQL basics

su - postgres
psql -d template1
\l -> list databases
\d -> list tables
\d  -> show table description
\c -> connect to database
\q -> quit