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;