MY_TRIGGERS

MY_TRIGGERS displays information about the triggers owned by the current user. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** MY_TRIGGERS columns
Name	Type	Description
owner	character varying(128)	Trigger owner.
trigger_name	character varying(64)	Trigger name.
trigger_type	character varying	Trigger type, which can be before statement, before each row, after statement, after each row, or instead of.
triggering_event	character varying	Event that triggers a trigger. The value can be update, insert, delete, or truncate.
table_owner	character varying(64)	Owner of the table that defines a trigger.
base_object_type	character varying(18)	Basic object type of a trigger, which can be table or view.
table_name	character varying(64)	Name of the table or view that defines a trigger.
column_name	character varying(4000)	Not supported. The value is NULL.
referencing_name	character varying(422)	Not supported. Set it to referencing new as new old as old.
when_clause	character varying(4000)	Content of when. TRUE must be evaluated as TRIGGER_BODY to execute.
status	character varying(64)	O: The trigger is enabled in origin or local mode. D: The trigger is disabled. R: The trigger is enabled in replica mode. A: The trigger is always enabled.
description	character varying(4000)	Trigger description, which is used to rebuild a trigger creation statement.
action_type	character varying(11)	Action type of a trigger, which only supports call.
trigger_body	text	Statement executed when a trigger is triggered.
crossedition	character varying(7)	Not supported. The value is NULL.
before_statement	character varying(3)	Not supported. The value is NULL.
before_row	character varying(3)	Not supported. The value is NULL.
after_row	character varying(3)	Not supported. The value is NULL.
after_statement	character varying(3)	Not supported. The value is NULL.
instead_of_row	character varying(3)	Not supported. The value is NULL.
fire_once	character varying(3)	Not supported. The value is NULL.
apply_server_only	character varying(3)	Not supported. The value is NULL.