postgres 查询数据库所有表名

select relname as TABLE_NAME ,col_description(c.oid, 0) as COMMENTS from pg_class c
where relkind = 'r' and relname not like 'pg_%' and relname not like 'sql_%' order by relname

原文地址:https://www.cnblogs.com/kevinge/p/4054059.html