pg_event_trigger
The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, evtname, evtevent, evtowner, evtfoid, evtenabled, evttags
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_event_trigger stores event triggers. See Chapter 38 for more information.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| evtname | name | Not null | Trigger name (must be unique) |
| evtevent | name | Not null | Identifies the event for which this trigger fires |
| evtowner | oid | Not null | Owner of the event trigger |
| evtfoid | oid | Not null | The function to be called |
| evtenabled | char | Not null | 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[] | Nullable | 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. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:f4da04252092e7e7b627e9dd7420d7c1083672b2e6671dea5a88e7e84ab0af72
Text language: en · catalog-bilingual-repair:f4da04252092e7e7b627e9dd7420d7c1083672b2e6671dea5a88e7e84ab0af72