The catalog pg_event_trigger stores event triggers.
| Column | Type | Description |
|---|---|---|
oid | oid | Row identifier. |
evtname | name | Trigger name (must be unique). |
evtevent | name | The event that fires this trigger. |
evtowner | oid | Owner of the event trigger. |
evtfoid | oid | The function to be called. |
evtenabled | char | Controls in which session_replication_role modes the event trigger fires. Valid values: O = fires in "origin" and "local" modes, D = disabled, R = fires in "replica" mode, A = always fires. |
evttags | text[] | Command tags for which this trigger fires. If NULL, the trigger is not restricted by command tag. |
To list all event triggers and their current status, run:
SELECT evtname, evtevent, evtenabled FROM pg_event_trigger;