1、查看表信息:
SELECT
A.attnum as 序号,
A .attname AS 字段名,
null as 含义,
format_type (A .atttypid, A .atttypmod) AS 数据类型,
d.adsrc AS 缺省值,
CASE
WHEN A .attnotnull THEN
'否'
ELSE
'是'
END AS 是否可以为空,
col_description (A .attrelid, A .attnum) AS 备注
FROM
pg_class C,
pg_attribute A
LEFT JOIN (
SELECT
A .attname,
ad.adsrc
FROM
pg_class C,
pg_attribute A,
pg_attrdef ad
WHERE
relname = 'ana_pnr'
AND ad.adrelid = C .oid
AND adnum = A .attnum
AND attrelid = C .oid
) AS d ON A .attname = d.attname
WHERE
C .relname = 'ana_pnr'
AND A .attrelid = C .oid
AND A .attnum > 0;
2、表汇总信息
SELECT
t1.tablename,
obj_description (t2.oid) AS table_comment
FROM
pg_tables t1,
pg_class t2
WHERE
t1.tablename = t2.relname
AND t1.schemaname = 'scheme名'
ORDER BY
t1.tablename ASC