PostgreSQL “DESCRIBE TABLE”

postgresqlpsqltable-structure

How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL (using the psql command)?

Best Solution

Try this (in the psql command-line tool):

\d+ tablename

See the manual for more info.