psql查包含某些或某个字段名的表

# 查包含某些字段名的表 字段名会区分大小写
SELECTc.relname as table_name,a.attname as field_name
FROM pg_class as c,pg_attribute as a
where a.attrelid = c.oid and a.attnum>0
and a.attname in ('f_is_need_front','F_email','passid','phone')
group by c.relname,a.attname
order by 1;