PG数据库表及表注释查询语句

--查询表名和表注释

select relname as tabname,
cast(obj_description(relfilenode,'pg_class') as varchar) as comment
from pg_class c;

--查询字段名，字段注释及字段长度和字段注释
select a.attnum as 序号,
c.relname as 表名,
cast(obj_description(relfilenode,'pg_class') as varchar) as 表名描述,
a.attname as 列名,
--concat_ws('',typname,substring(format_type(a.atttypmod) from '.∗" role="presentation" style="position: relative;">.∗$.\ast$')) as 字段类型,
d.description as 备注
from pg_class c,
pg_attribute a,
pg_type t,
pg_description d
where a.attnum>0
and a.attrelid=c.oid
and a.atttypid=t.oid
and d.objoid=a.attrelid
and d.objsubid=a.attnum
order by c.relname desc,a.attnum asc;