Connect to the database:
psql [-U username] [-h hostname] database-name

To list all databases, type either one of the following:
\l
\list

To list tables in a current database, type:
\dt

To describe a table, type:
\d <table-name>

 

From http://onewebsql.com/

Advertisements