Updated on 2024-09-02 GMT+08:00

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.