47.12. pg_event_trigger

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.

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

Table 47-12. 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.