查询所有表名称以及字段含义select c.relname 表名,cast(obj_description(relfilenode,‘pg_class’) as varchar) 名称,a.attname 字段,d.description 字段备注,concat_ws(’’,t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from ‘(.)’)) as 列类型 from pg_class c,pg_attribute a,pg_type t,pg_description dwhere a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oid and d.objoid=a.attrelid and d.objsubid=a.attnumand c.relname in (select tablename from pg_tables where schemaname=‘public’ and position(’_2’ in tablename)=0) order by c.relname,a.attnum查看所有表名select tablename from pg_tables where schemaname=‘public’ and position(’_2’ in tablename)=0;select * from pg_tables;查看表名和备注select relname as tabname,cast(obj_description(relfilenode,‘pg_class’) as varchar) as comment from pg_class cwhere relname in (select tablename from pg_tables where schemaname=‘public’ and position(’_2’ in tablename)=0);select * from pg_class;查看特定表名备注select relname as tabname,cast(obj_description(relfilenode,‘pg_class’) as varchar) as comment from pg_class c where relname =‘tbl_alarm’;查看特定表名字段select a.attnum,a.attname,concat_ws(’’,t.typname,SUBSTRING(format_type(a.atttypid,a.atttypmod) from ‘(.)’)) as type,d.description from pg_class c,pg_attribute a,pg_type t,pg_description dwhere c.relname=‘tbl_alarm’ and a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oid and d.objoid=a.attrelid and d.objsubid=a.attnum;