查询所有表及字段说明

SELECT relname                                                   AS 表名,
       cast(obj_description(relfilenode, 'pg_class') AS VARCHAR) AS 表说明,
       a.attname                                                 AS 字段名,
       col_description(a.attrelid, a.attnum)                     AS 字段说明,
       format_type(a.atttypid, a.atttypmod)                      AS 字段类型,
       a.attnotnull                                              AS notnull
FROM pg_class AS c,
     pg_attribute AS a
WHERE a.attrelid = c.oid
  and c.relnamespace='2200'
  and c.relname like '%mdcs%'
  AND a.attnum > 0;
select *
from pg_class;

SELECT relname                                                   AS 表名,
       cast(obj_description(relfilenode, 'pg_class') AS VARCHAR) AS 表说明,
       a.attname                                                 AS 字段名,
       col_description(a.attrelid, a.attnum)                     AS 字段说明,
       format_type(a.atttypid, a.atttypmod)                      AS 字段类型,
       a.attnotnull                                              AS notnull
FROM pg_class AS c,
     pg_attribute AS a
WHERE a.attrelid = c.oid
  and c.relnamespace='2200'
  and c.relname like '%mdcs%'
  and c.relname not like '%v_mdcs%'
  and c.relname not like '%_pkey%'
  AND a.attnum > 0;
select *
from pg_class;