select a.schemaname,a.tablename,c.oid,d.description from pg_tables a
left join pg_class c on relname=tablename
left join pg_description d on oid=objoid and objsubid=0
结果展示
image.png
如果仅查询某一个 schema 的表，只需要添加一个 where 条件
select a.schemaname,a.tablename,c.oid,d.description from pg_tables a
left join pg_class c on relname=tablename
left join pg_description d on oid=objoid and objsubid=0
where schemaname='public'
结果展示
image.png
