pg_event_trigger — PostgreSQL system catalog

The PostgreSQL pg_event_trigger system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  1 min read

Summary

The catalog pg_event_trigger stores event triggers. See event_triggers for more information.

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_event_trigger system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • oid oid
    Row identifier
  • evtname name
    Trigger name (must be unique)
  • evtevent name
    Identifies the event for which this trigger fires
  • evtowner oid references pg_authid.oid
    Owner of the event trigger
  • evtfoid oid references pg_proc.oid
    The function to be called
  • evtenabled char
    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.
  • evttags text[]
    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.

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_event_trigger.