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