查看一个表的字段:
查看一个库的表
SELECT a.attname as name,format_type(a.atttypid,a.atttypmod) as type, col_description(a.attrelid,a.attnum) as comment,a.attnotnull as notnull
FROM pg_class as c,pg_attribute as a
where a.attrelid = c.oid and a.attnum>0 and c.relname = 'my1'
查看一个库的表
select * from pg_tables where schemaname ='public';