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.