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‘