PostgreSQL

PostgreSQL Elephant Logo

52.21. pg_event_trigger

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

Table 52.21. pg_event_trigger Columns

Name Type References Description

evtname

name

Trigger name (must be unique)

evtevent

name

Identifies the event for which this trigger fires

evtowner

oid

pg_authid.oid

Owner of the event trigger

evtfoid

oid

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 “[.quote]#origin”# and “[.quote]#local”# modes, D = trigger is disabled, R = trigger fires in “[.quote]#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.

+

Prev Up Next

52.20. pg_enum

Home

52.22. pg_extension

Copyright © 1996-2023 The PostgreSQL Global Development Group