postgresql 实现获取所有表名,字段名,字段类型,注释

获取表名及注释：

select relname as tabname,cast(obj_description(relfilenode,’pg_class’) as varchar) as comment from pg_class c
where relkind = ‘r’ and relname not like ‘pg_%’ and relname not like ‘sql_%’ order by relname