postgresql commands

Useful postgresql commands:

login [assuming no password required]:

postgresql -d <database name> -h <host name> -U <user name>

List schemas:

\dn

List tables in schema THE_SCHEMA:

\dt THE_SCHEMA.*

Describe table THE_SCHEMA.THE_TABLE:

\d THE_SCHEMA.THE_TABLE