pg查询所有表名称以及字段含义

查询所有表名称以及字段含义
SELECT
b.schemaname,
A.*
FROM
(SELECT C
.relname,
A.attnum,
A.attname,
--T.typname AS TYPE,
concat_ws ( '', T.typname, SUBSTRING ( format_type ( A.atttypid, A.atttypmod ) FROM '\(.*\)' ) ) AS TYPE,
A.attnotnull AS NOTNULL,
b.description AS COMMENT
FROM
pg_class C,
pg_attribute
A LEFT OUTER JOIN pg_description b ON A.attrelid = b.objoid
AND A.attnum = b.objsubid,
pg_type T
WHERE
A.attnum > 0
AND A.attrelid = C.oid
AND A.atttypid = T.oid
AND A.attstattarget = - 1
ORDER BY
A.attnum
)
A LEFT JOIN pg_tables b ON b.tablename = A.relname
WHERE
b.tablename IS NOT NULL
--AND schemaname IN ( 'xxx', 'xxx', 'xxx'.... )
AND schemaname = 'ods_test'
ORDER BY
schemaname||relname ,
attnum





原文链接：https://blog.csdn.net/weixin_44994948/article/details/119727868