查看PG当前数据库所有表的注释

郑全

使用以下SQL语句可以查询：

SELECT
    n.nspname AS schema_name,
    c.relname AS table_name,
    obj_description(c.oid, 'pg_class') AS table_comment,
    pg_size_pretty(pg_total_relation_size(c.oid)) AS total_size,
    c.reltuples AS estimated_rows
FROM pg_class c
JOIN pg_namespace n ON n.oid = c.relnamespace
WHERE c.relkind = 'r'
  AND n.nspname = 'public'  -- 替换为你的模式名
ORDER BY c.relname;