您的位置:首页 > 博客中心 > 数据库 >

PostgreSQL 获取含有某字段的 table

时间:2022-03-14 06:36

需求:找到所有的含有 n_jbfy 的表名

SELECT
 c.relname,
 col_description (a.attrelid, a.attnum) AS COMMENT,
 format_type (a.atttypid, a.atttypmod) AS TYPE,
 a.attname AS NAME,
 a.attnotnull AS notnull
FROM
  aty_class AS c,
 aty_attribute AS a
WHERE a.attrelid = c.oid
 AND a.attnum > 0
 AND a.attname = ‘n_jbfy‘

本类排行

今日推荐

热门手游