postgresql查询所有表中是否存在某个字段

select b.oid, b.relname, att.attname, b.relkind,attinhcount, atttypmod
from pg_attribute att, pg_class b
where b.oid = att.attrelid
and att.attname = 'column_name' --可以模糊查询 '%column_name%'
and attinhcount in (0)
and b.relkind in ('r')
order by b.relname, atttypmod;