↑↓ select↵ open⌫ change scopeOpen full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3
Historical version. PostgreSQL 9.6 has reached end of support. 2021-11-11. See the current manual.

50.21. pg_event_trigger

The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information.

Table 50-21. pg_event_trigger Columns

NameTypeReferencesDescription
evtnamename Trigger name (must be unique)
evteventname Identifies the event for which this trigger fires
evtowneroidpg_authid.oidOwner of the event trigger
evtfoidoidpg_proc.oidThe function to be called
evtenabledchar  Controls in which session_replication_role modes the event trigger fires. O = trigger fires in "origin" and "local" modes, D = trigger is disabled, R = trigger fires in "replica" mode, A = trigger fires always.
evttagstext[]  Command tags for which this trigger will fire. If NULL, the firing of this trigger is not restricted on the basis of the command tag.

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.