[PostgreSQL] 트리거 조회


[PostgreSQL] 트리거 조회

--foreign key 걸린테이블 목록확인 SELECT kcu.table_name AS child_table, kcu.table_schema AS child_schema, kcu.column_name AS child_column, kcu.constraint_name AS child_constraint FROM information_schema.table_constraints tc JOIN information_schema.key_column_usage kcu ON tc.constraint_name = kcu.constraint_name JOIN information_schema.constraint_column_usage ccu ON ccu.constraint_name = tc.constraint_nam..


원문링크 : [PostgreSQL] 트리거 조회