Display the structure of PostgreSQL/PgSQL table fields
Contributed by Rex 
December 17, 2003 
Tagged: PostgreSQL PgSQL
From within the psql monitor, issue the following command to view the structure of the table named ‘elephants’
\d elephants