postgre使用

查看一个表的字段：

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';