select
A.relname as 表名,
B.attname AS 字段名,
B.attnum as 字段排序,
format_type (B.atttypid,B.atttypmod ) AS 数据类型及长度,
B.attnotnull AS 非空,
col_description ( B.attrelid, B.attnum ) AS 字段描述
from
pg_class A
left join pg_attribute B on
A.oid = B.attrelid AND B.attnum > 0