PostgreSQL “DESCRIBE TABLE”
Try this (in the psql command-line tool): \d+ tablename See the manual for more info.
postgresql
PostgreSQL: Show tables in PostgreSQL
From the psql command line interface, First, choose your database \c database_name Then, this shows all tables in the current schema: \dt Programmatically (or from the psql interface too, of course): SELECT * FROM pg_catalog.pg_tables; The system tables live in the pg_catalog database.