PostgreSQL Data Dictionary

PostgresDataDictionary.sql

SELECT DISTINCT ON
  ( table_schema, table_name, ordinal_position ) table_schema,
  table_name,
  ordinal_position,
  column_name,
  data_type,
  column_default,
  is_nullable,
  pg_description.description
FROM
  information_schema.columns
  JOIN pg_catalog.pg_class ON pg_class.relname = columns.table_name 
  LEFT OUTER JOIN pg_catalog.pg_description ON pg_description.objoid = pg_class.relfilenode 
  AND pg_description.objsubid = columns.ordinal_position 
WHERE
  table_schema IN ( 'wq', 'logging' ) 
ORDER BY
  table_schema,
  table_name,
  ordinal_position