根据特定字段和注释查询表清单

最新推荐文章于 2023-11-22 10:09:34 发布

波特王子

最新推荐文章于 2023-11-22 10:09:34 发布

阅读量1.4k

点赞数

CC 4.0 BY-SA版权

分类专栏： Greenplum相关数据库开发

本文链接：https://blog.youkuaiyun.com/sptoor/article/details/18034567

数据库开发同时被 2 个专栏收录

93 篇文章

订阅专栏

Greenplum相关

35 篇文章

订阅专栏

本文介绍了一种使用SQL查询特定字段及注释的方法，通过联接多个表来获取详细信息，并展示了如何筛选包含特定词汇的字段。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

根据特定字段和注释查询表清单：

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,
	pg_class.relstorage
 FROM
       pg_catalog.pg_attribute a
       INNER JOIN pg_class  ON a.attrelid = pg_class.oid and pg_class.relstorage not in ('x', 'v')  AND pg_class.relname not like '%\_1\_prt\_%'
       INNER JOIN pg_namespace ON pg_class.relnamespace = pg_namespace.oid AND pg_namespace.nspname not in ('my_schema1', 'my_schema2')
       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 '%bill%' or like '%pay%' 
 or fields_comment like '%信用%' or fields_comment like '%护照%' or fields_comment like '%支付%' or fields_comment like '%联系%' or fields_comment like '%身份%' or fields_comment like '%银行%' 
 order by 1,2,3