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

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_event_trigger

Read PG 18 manual ↗

The catalog pg_event_trigger stores event triggers.

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

Columns 7

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`evtname`	`name`	Trigger name (must be unique)
`evtevent`	`name`	Identifies the event for which this trigger fires
`evtowner`	`oid`	Owner of the event trigger pg_authid.oid
`evtfoid`	`oid`	The function to be called pg_proc.oid
`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.

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`evtname`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`evtevent`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`evtowner`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`evtfoid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`evtenabled`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`evttags`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`oid`	·	·	·	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●

Version history 8

Definition snapshot: english-manuals:9e34efd14a6cd1d285072bb493e… · English manual source