HomeMogDBMogDB StackUqbar
v1.1

Documentation:v1.1

Supported Versions:

PG_TRIGGER

PG_TRIGGER records trigger information.

Table 1 PG_TRIGGER columns

Name Type Description
oid oid Row identifier (hidden attribute, which must be specified)
tgrelid oid OID of the table where the trigger is located
tgname name Trigger name
tgfoid oid The function to be called by the trigger.
tgtype smallint Trigger type
tgenabled "char" - O: The trigger is triggered in origin or local mode.
- D: The trigger is disabled.
- R: The trigger is triggered in replica mode.
- A: The trigger is always triggered.
tgisinternal boolean Whether the trigger is an internal trigger
tgconstrrelid oid Table referenced by the integrity constraint
tgconstrindid oid Index of the integrity constraint
tgconstraint oid OID of the constraint trigger in PG_CONSTRAINT
tgdeferrable boolean Whether the constraint trigger is of the DEFERRABLE type
tginitdeferred boolean Whether the trigger is of the INITIALLY DEFERRED type
tgnargs smallint Number of input parameters of the trigger function
tgattr int2vector Column ID specified by the trigger. If no column is specified, an empty array is used.
tgargs bytea Parameter transferred to the trigger
tgqual pg_node_tree WHEN condition of the trigger (NULL if the WHEN condition does not exist)
tgowner oid trigger owner
Copyright © 2011-2024 www.enmotech.com All rights reserved.