查询一些特定表的注释:
select ns.nspname, pg_class.relname, pg_description.description
from pg_namespace ns
inner join pg_class on ns.oid=pg_class.relnamespace and ns.nspname = 'my_schema'
inner join pg_description on pg_description.objoid = pg_class.oid and pg_description.objsubid=0
pg_description.objsubid不等于0 表示该注释为某列的注释,这个数字为列id。等于0表示为非列(表和其它对象)的注释。