PostgreSQL 获取含有某字段的 table

需求：找到所有的含有 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‘

PostgreSQL 获取含有某字段的 table

原文：http://blog.csdn.net/u011598529/article/details/44116161