PostgreSql 获取表结构和字段注释

select 
    a.attnum,
    n.nspname,
    c.relname,
    a.attname as field,
    t.typname as type,
    a.attlen as length,
    a.atttypmod as lengthvar,
    a.attnotnull as notnull,
    b.description as comment 
from
    pg_namespace n left join pg_class c
    on n.oid = c.relnamespace
    left join pg_attribute a 
    on a.attrelid = c.oid
    left join pg_description b 
    on a.attrelid = b.objoid and a.attnum = b.objsubid
    left join pg_type t 
    on a.atttypid = t.oid
where
    n.nspname = 'test'
    and c.relname = 'src'
    and a.attnum > 0   
order by
    a.attnum;