List table columns in PostgreSQL database

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16

SELECT table_schema
 ,table_name
 ,ordinal_position AS position
 ,column_name
 ,data_type
 ,CASE WHEN character_maximum_length IS NOT NULL
  THEN character_maximum_length
  ELSE numeric_precision
  END AS max_length
 ,is_nullable
 ,column_default AS default_value
FROM information_schema.columns
WHERE table_schema NOT IN ('information_schema', 'pg_catalog')
ORDER BY table_schema
 ,table_name
 ,ordinal_position;