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;