[PostgreSQL] trigger code source 확인하기

트리거 생성 후, 소스코드를 확인하기 위한 쿼리.

 

1. 

SELECT tgrelid FROM pg_trigger  WHERE tgname=<trigger name>;

ex) SELECT tgrelid FROM pg_trigger  WHERE tgname='trg_name';

 

2.

SELECT oid,relname  FROM pg_class WHERE oid=<oid>;

ex) SELECT oid,relname  FROM pg_class WHERE oid=49826;

 

3.

SELECT prosrc FROM pg_proc WHERE proname = <function name>;

ex) SELECT prosrc FROM pg_proc WHERE proname = 'function name';

 

4. 

SELECT event_object_table,trigger_name,event_manipulation,action_statement,action_timing 
FROM information_schema.triggers 
WHERE event_object_table='table name' 
ORDER BY event_object_table,event_manipulation