pg_trigger

The pg_trigger system catalog table stores triggers on tables.

Note: Greenplum Database does not support triggers.

columntypereferencesdescription
tgrelidoidpg_class.oid
Note that Greenplum Database does not enforce referential integrity.
The table this trigger is on.
tgnamename Trigger name (must be unique among triggers of same table).
tgfoidoidpg_proc.oid
Note that Greenplum Database does not enforce referential integrity.
The function to be called.
tgtypeint2 Bit mask identifying trigger conditions.
tgenabledboolean True if trigger is enabled.
tgisconstraintboolean True if trigger implements a referential integrity constraint.
tgconstrnamename Referential integrity constraint name.
tgconstrrelidoidpg_class.oid
Note that Greenplum Database does not enforce referential integrity.
The table referenced by an referential integrity constraint.
tgdeferrableboolean True if deferrable.
tginitdeferredboolean True if initially deferred.
tgnargsint2 Number of argument strings passed to trigger function.
tgattrint2vector Currently not used.
tgargsbytea Argument strings to pass to trigger, each NULL-terminated.

Parent topic: System Catalogs Definitions