如何在postgresql中查找具有特定列的表

3 回答

• 45

  你可以查询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'
  

  sql fiddle demo

  回复于 2024-05-22T03:28:35+08:00
• 4

  你也可以

  select table_name from information_schema.columns where column_name = 'your_column_name'
  

  回复于 2024-05-22T03:28:35+08:00
• 109

  我已经使用@Roman Pekar的查询作为基础并添加了模式名称（在我的情况下相关）

  select n.nspname as schema ,c.relname
      from pg_class as c
      inner join pg_attribute as a on a.attrelid = c.oid
      inner join pg_namespace as n on c.relnamespace = n.oid
  where a.attname = 'id_number' and c.relkind = 'r'
  

  sql fiddle demo

  回复于 2024-05-22T03:28:35+08:00