↑↓ select ↵ open ⌫ change scope Open full search

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

System Catalogs / System catalogs

pg_event_trigger

Read the PG 18 manual

The catalog pg_event_trigger stores event triggers.

Reading PG 18current·documented in 15 of 24 versions, 9.3 to 20

Kind
System catalogs
Columns in this snapshot
7
Definition source
English manual
Metadata snapshot
18.6

Columns 7

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
oidoidNOT NULLRow identifier
evtnamenameNOT NULLTrigger name (must be unique)
evteventnameNOT NULLIdentifies the event for which this trigger fires
evtowneroidNOT NULLOwner of the event trigger
pg_authid.oid
evtfoidoidNOT NULLThe function to be called
pg_proc.oid
evtenabledcharNOT NULLControls 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.
Column history across versions
Version history 8
  1. 16 → 17 reworded
  2. 13 → 14 reworded
  3. 12 → 13 reworded
  4. 11 → 12 changed
  5. 10 → 11 reworded
  6. 9.6 → 10 reworded
  7. 9.5 → 9.6 reworded
  8. 9.2 → 9.3 added

Definition snapshot: english-manuals:d164b331d1f818cb86402470e79… · English manual source