triggers

The triggers view provides information about all triggers on tables and views.

Column name	Data type	Description
trigger_catalog	sql_identifier	The name of the current database containing the trigger.
trigger_schema	sql_identifier	The name of the schema containing the trigger.
trigger_name	sql_identifier	The name of the trigger.
event_manipulation	character_data	An event that fires the trigger. The possible options are: INSERT UPDATE DELETE
event_object_catalog	sql_identifier	The name of the current database containing the table on which the trigger is defined.
event_object_schema	sql_identifier	The name of the schema containing the table on which the trigger is defined.
event_object_table	sql_identifier	The name of the table on which the trigger is defined.
action_order	cardinal_number	A firing order among triggers on the same table with the same event, timing, and orientation. Note: PostgreSQL fires triggers in name order.
action_condition	character_data	The WHEN condition of the trigger. NULL – None or the table is not owned by a currently enabled role.
action_statement	character_data	A statement executed by the trigger. Always EXECUTE FUNCTION function(...).
action_orientation	character_data	Specifies whether the trigger fires per row (ROW) or per statement (STATEMENT).
action_timing	character_data	Time at which the trigger fires. The possible options are: BEFORE AFTER INSTEAD OF
action_reference_old_table	sql_identifier	The name of the “old” transition table. NULL – None.
action_reference_new_table	sql_identifier	The name of the “new” transition table. NULL – None.
action_reference_old_row	sql_identifier	Applies to a feature that is not available in PostgreSQL.
action_reference_new_row	sql_identifier	Applies to a feature that is not available in PostgreSQL.
created	time_stamp	Applies to a feature that is not available in PostgreSQL.