pg_event_trigger

The pg_event_trigger catalog provides information about event triggers.

Column name	Data type	Description
oid	oid	A row identifier.
evtname	name	The name of the event trigger. Note: The value must be unique.
evtevent	name	The event for which the trigger fires.
evtowner	oid (references pg_authid.oid)	The OID of the role that owns the event trigger.
evtfoid	oid (references pg_proc.oid)	The OID of the function that is executed when the trigger fires.
evtenabled	char	Specifies the session_replication_role modes in which the trigger fires. The following modes are available: O – Fires in “origin” and “local” modes. D – Disabled. R – Fires in “replica” mode. A – Always fires.
evttags	text[]	The list of command tags for which this trigger fires. If NULL, the trigger is not restricted by command tag.