PG_TRIGGER
PG_TRIGGER records the trigger information.
Name |
Type |
Description |
---|---|---|
tgrelid |
oid |
OID of the table where the trigger is located. |
tgname |
name |
Trigger name. |
tgfoid |
oid |
Trigger OID. |
tgtype |
smallint |
Trigger type |
tgenabled |
"char" |
O: The trigger fires in "origin" or "local" mode. D: The trigger is disabled. R: The trigger fires in "replica" mode. A: The trigger always fires. |
tgisinternal |
boolean |
Internal trigger ID. If the value is true, it indicates an internal trigger. |
tgconstrrelid |
oid |
The table referenced by the integrity constraint |
tgconstrindid |
oid |
Index of the integrity constraint |
tgconstraint |
oid |
OID of the constraint trigger in the pg_constraint |
tgdeferrable |
boolean |
The constraint trigger is of the DEFERRABLE type. |
tginitdeferred |
boolean |
whether the trigger is of the INITIALLY DEFERRED type |
tgnargs |
smallint |
Input parameters number 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 |
Indicates the WHEN condition of the trigger. If the WHEN condition does not exist, the value is null. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot