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
|
Function to be invoked 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
|
Internal trigger ID. If the value is true, it indicates 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
|
tgordername
|
name
|
Original trigger name
|
tgorder
|
name
|
Whether the trigger controls the triggering sequence
|
tgtime
|
name
|
Time when the trigger is created
|
