Le portail francophone de la géomatique

    SELECT table_schema, table_name, description_table, column_name, data_type,
    description_column
    from (
    SELECT distinct
    info.table_schema,info.table_name, pde.description as description_table, ''::text
    as column_name, ''::text as data_type, ''::text as description_column
    from
    (select c.*, pc.*, pc.oid as oid
    from pg_catalog.pg_class as pc, information_schema.columns as c
    where pc.relname=c.table_name and c.table_schema != 'information_schema'
    and c.table_schema != 'pg_catalog') as info
    LEFT OUTER JOIN
    (SELECT pc.*, PD.*
    FROM pg_catalog.pg_description PD right outer join
    pg_catalog.pg_class PC
    on PD.objoid = PC.oid AND PD.objsubid = 0 ) as pde
    on info.oid = pde.objoid
UNION
    SELECT info.relname, info.table_name, ''::text as description_table,
    info.column_name,info.data_type, pde.description
    from
    (select c.table_schema, c.table_name, pc.relname, c.data_type,
    c.column_name, c.ordinal_position, pc.oid
    from pg_catalog.pg_class as pc, information_schema.columns as c where
    pc.relname=c.table_name ORDER BY c.ordinal_position
    ) as info
    LEFT OUTER JOIN
    (select pd.objsubid, pd.objoid, pd.description, pc.relname
    from pg_catalog.pg_class as pc, pg_catalog.pg_description as pd where (pc.oid=pd.objoid)
    ) as pde
    on info.ordinal_position=pde.objsubid and info.table_name = pde.relname
    ) as uni
;