PostgreSQL数据库查看表名模式注释等信息可通过查询PG的元数据查看，脚本如下：

-- 查询表的信息，包括表名、模式、类型等
SELECT
  t.schemaname,t.tablename,c.oid AS tableoid,n.oid AS nspoid,d.description
FROM pg_tables t
  JOIN pg_namespace n ON t.schemaname=n.nspname
  JOIN pg_class c ON t.tablename=c.relname AND n.oid=c.relnamespace -- 不加n.oid=c.relnamespace会带跨模式表名重复的
  LEFT JOIN pg_description d ON d.objoid=c.oid AND d.objsubid=0 -- objusbid=0表示表注释，后创建也是0，列注释从1开始
WHERE schemaname='tmp' -- 查看指定模式下的
ORDER BY schemaname,tablename;

也可通过下面的SQL查询：

-- 查询所有表注释
SELECT
  tb.table_schema,tb.table_name,d.description,c.oid AS table_id
FROM information_schema.tables tb JOIN pg_namespace n ON tb.table_schema=n.nspname
  JOIN pg_class c ON c.relname = tb.table_name AND c.relnamespace=n.oid
  LEFT JOIN pg_description d ON d.objoid = c.oid AND d.objsubid = 0
WHERE tb.table_schema = 'ods'; -- 查看指定模式下的