PG_TRIGGER
PG_TRIGGER records the trigger information.
| Column | 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 | 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 | 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.
