根据字段或者注释查询表清单

select * from 
(SELECT pg_namespace.nspname
       , pg_class.relname
       ,a.attname AS fields_name,
       pg_catalog.format_type(a.atttypid, a.atttypmod),
       pg_description.description AS fields_comment
 FROM
       pg_catalog.pg_attribute a
       INNER JOIN pg_class  ON a.attrelid = pg_class.oid  -- AND pg_class.relname='res_passenger'
       INNER JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid --AND pg_namespace.nspname not in ('schema_name1','schema_name2')
       INNER JOIN pg_type   ON a.atttypid = pg_type.oid
       LEFT OUTER JOIN pg_description ON pg_description.objoid = pg_class.oid AND pg_description.objsubid = a.attnum
 WHERE
       a.attnum > 0
       AND attisdropped <> 't' 
       AND a.attname <> 'oid'
 ORDER BY a.attnum ) b 
 where fields_name like '%filed_name_pattern%' or fields_comment like '%comment_pattern%'
 order by 1,2,3