weixin_44296167的博客

1、查询表名和表注释 select relname as tabname, cast(obj_description(relfilenode,'pg_class') as varchar) as comment from pg_class c whererelname ='table_name' ; 2、查询字段名、字段类型及字段长度和字段注释 select a.attnum,a.at...