人大金仓查询表以及表注释 表字段注释

-- 查询表以及表注释
SELECT
  "table_name", t2.description
FROM information_schema.tables
left join (select * from pg_description where objsubid = 0) t2 on table_name::regclass::oid = t2.objoid
WHERE table_schema = 'public' AND table_type = 'BASE TABLE';

-- 查询表字段以及类型注释等
select table_name::regclass::oid, "column_name", data_type,
character_maximum_length, t2.description
from information_schema.COLUMNS t1
left