PostgreSQL 获取含有某字段的 table

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

SELECTc.relname,col_description (a.attrelid, a.attnum) AS COMMENT,format_type (a.atttypid, a.atttypmod) AS TYPE,a.attname AS NAME,a.attnotnull AS notnullFROMaty_class AS c,aty_attribute AS aWHERE a.attrelid = c.oidAND a.attnum > 0AND a.attname = ‘n_jbfy’

，世上没有绝望的处境，只有对处境绝望的人。