Trigger Functions¶
pg_get_triggerdef(oid)¶
Description: Obtains the definition information of a trigger.
Parameter: OID of the trigger to be queried
Return type: text
Example:
SELECT pg_get_triggerdef(oid) FROM pg_trigger;
pg_get_triggerdef
----------------------------------------------------------------------------------------------------------------------
CREATE TRIGGER insert_trigger BEFORE INSERT ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_insert_func()
(1 row)
pg_get_triggerdef(oid, boolean)¶
Description: Obtains the definition information of a trigger.
Parameter: OID of the trigger to be queried and whether it is displayed in pretty mode
Return type: text
Note
The Boolean parameters take effect only when the WHEN condition is specified during trigger creation.
Example:
SELECT pg_get_triggerdef(oid,true) FROM pg_trigger;
pg_get_triggerdef
----------------------------------------------------------------------------------------------------------------------
CREATE TRIGGER insert_trigger BEFORE INSERT ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_insert_func()
(1 row)
SELECT pg_get_triggerdef(oid,false) FROM pg_trigger;
pg_get_triggerdef
----------------------------------------------------------------------------------------------------------------------
CREATE TRIGGER insert_trigger BEFORE INSERT ON test_trigger_src_tbl FOR EACH ROW EXECUTE PROCEDURE tri_insert_func()
(1 row)