pg数据库如何查询全库字段与注释

你可以使用以下的SQL语句来查询 pg 数据库中全库的字段名和注释：

SELECT
    c.relname AS table_name,
    a.attname AS column_name,
    pg_catalog.col_description(a.attrelid, a.attnum) AS column_comment
FROM
    pg_catalog.pg_attribute a
    INNER JOIN pg_catalog.pg_class c ON a.attrelid = c.oid
WHERE
    a.attnum > 0 AND
    NOT a.attisdropped AND
    c.relkind = 'r'
ORDER BY
    c.relname ASC,
    a.attnum ASC;

这个 SQL 语句会返回一个结果集，其中包含了每个表的每个字段及其对应的注释。