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. |
Last Article: PG_TABLESPACE
Next Article: PG_TS_CONFIG
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.