How do you perform the equivalent of Oracle's DESCRIBE TABLE in PostgreSQL with psql command?
DESCRIBE TABLE
Try this (in the psql command-line tool):
psql
\d+ tablename
See the manual for more info.