데이터베이스/PostgreSQL
PostgreSQL 컬럼명으로 Table 찾기
ddss6565
2023. 7. 18. 02:36
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% 부분에 원하는 컬럼명 입력
반응형