pg_trigger

tgrelid

oid

pg_class.oid
(see a note)

The table this trigger is on

tgname

name

 — 

Trigger name (must be unique among triggers of the same table)

tgfoid

oid

pg_proc.oid
(see a note)

The function to be called

tgtype

int2

 — 

Bit mask identifying trigger conditions

tgenabled

boolean

 — 

true if trigger is enabled

tgisinternal

boolean

 — 

true if trigger is internally generated (usually, to enforce the constraint identified by tgconstraint)

tgconstrrelid

oid

pg_class.oid
(see a note)

The table referenced by the referential integrity constraint

tgconstrindid

oid

pg_class.oid

The index supporting a unique, primary key, or referential integrity constraint

tgconstraint

oid

pg_constraint.oid

The pg_constraint entry associated with the trigger, if any

tgdeferrable

boolean

 — 

true if deferrable

tginitdeferred

boolean

 — 

true if initially deferred

tgnargs

int2

 — 

Number of argument strings passed to trigger function

tgattr

int2vector

 — 

Currently not used

tgargs

bytea

 — 

Argument strings to pass to trigger, each NULL-terminated

tgqual

pg_node_tree

 — 

Expression tree (in nodeToString() representation) for the trigger’s WHEN condition, or NULL if none