获取表名及注释: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过滤掉分表..
获取表字段:select * from user_tab_columns where Table_Name='用户表' order by column_name获取表注释:select * from user_tab_comments where Table_Name='用户表'order by Table_Name获取字段注释:select * from user_col_comments where T..