본문 바로가기
데이터베이스/PostgreSQL

PostgreSQL 컬럼명으로 Table 찾기

by ddss6565 2023. 7. 18.
SELECT t.table_schema
     , t.table_name
  FROM information_schema.tables t
  JOIN information_schema.columns c ON c.table_name = t.table_name AND c.table_schema = t.table_schema
 WHERE c.column_name like '%column_name%'
   AND t.table_schema not in ('information_schema', 'pg_catalog')
   AND t.table_type = 'BASE TABLE'
 ORDER BY t.table_schema

%column_name% 부분에  원하는 컬럼명 입력

반응형

댓글