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. |