Skip to main content

PostgreSQL

List column names of a table in Postgres​

SELECT column_name
FROM information_schema.columns
WHERE table_schema = 'public'
  AND table_name = 'your_table_name'
ORDER BY ordinal_position;

can select data_type, table_name etc. For complete list, replace column_name with *

psql terminal:

\d your_table_name