PostgreSQL “DESCRIBE TABLE” Try this (in the psql command-line tool): \d+ tablename See the manual for more info.
