我使用postgresql 9.1。我有一个表的列名。是否可以找到具有/具有此列的表?怎么样?提前致谢。
你可以查询
system catalogs:
- select c.relname
- from pg_class as c
- inner join pg_attribute as a on a.attrelid = c.oid
- where a.attname = <column name> and c.relkind = 'r'