1.表字段查询sql
SELECT
A.attnum AS "序号",
C.relname AS "表名",
A.attname AS "字段名",-- 字段名
t.typname as "字段类型", --字段类型
NULLIF(information_schema._pg_char_max_length(A.atttypid, A.atttypmod), -1) AS "字符串最大长度", -- 字符串最大长度
col_description ( A.attrelid, A.attnum ) AS "字段备注", -- 字段备注
A.attnotnull AS "是否非空" , -- 是否非空
A.atthasdef AS "是否存在默认值", --是否存在默认值
obj_description(c.relfilenode) AS "表名描述"
-- cast(obj_description(relfilenode,'pg_class') as varchar) AS "表名描述"
FROM
pg_class AS C,
pg_attribute AS A ,
pg_type as T
WHERE
C.relname IN (
select tablename from pg_tables where schemaname = 'public'
)
AND
A.attrelid = C.oid
AND A.atttypid= T.oid
AND A.attnum > 0
AND NOT A.attisdropped
ORDER BY C.relname, A.attnum ;
查询结果,导出