How to Show a Table Schema in PostgreSQL

Last updated July 25, 2026 · By the SaturnSQL team

In psql, \d tablename shows columns, types, indexes, and constraints (\d+ adds storage details). From SQL, query information_schema.columns, which works from any client.

\d orders
\d+ orders

SELECT column_name, data_type, is_nullable, column_default
FROM information_schema.columns
WHERE table_schema = 'public'
  AND table_name = 'orders'
ORDER BY ordinal_position;