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

結(jié)果展示

image.png

如果僅查詢某一個(gè) schema 的表，只需要添加一個(gè) 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'

結(jié)果展示

image.png