PG 查询所有表信息、表字段信息

2020-04-17   阅读(63)  


select * from pg_tables where tablename not like 'pg%' and tablename not like 'sql_%' order by tablename;



select tablename,obj_description(relfilenode,'pg_class')  from pg_tables  a, pg_class b
where a.tablename = b.relname and a.tablename not like 'pg%' and a.tablename not like 'sql_%' order by a.tablename;



select a.attname as fieldname, col_description(a.attrelid,a.attnum) as comment,format_type(a.atttypid,a.atttypmod) as type, a.attnotnull as notnull
from pg_class as c,pg_attribute as a
where c.relname = '表名称' and a.attrelid = c.oid and a.attnum > 0;


ConstXiong 备案号:苏ICP备16009629号-3