pg_trigger

pg_trigger

The pg_trigger system catalog table stores triggers on tables.

Note: Greenplum Database does not support triggers.
Table 1. pg_catalog.pg_trigger
column type references description
tgrelid oid pg_class.oid

Note that Greenplum Database does not enforce referential integrity.

The table this trigger is on.
tgname name   Trigger name (must be unique among triggers of same table).
tgfoid oid pg_proc.oid

Note that Greenplum Database does not enforce referential integrity.

The function to be called.
tgtype int2   Bit mask identifying trigger conditions.
tgenabled boolean   True if trigger is enabled.
tgisconstraint boolean   True if trigger implements a referential integrity constraint.
tgconstrname name   Referential integrity constraint name.
tgconstrrelid oid pg_class.oid

Note that Greenplum Database does not enforce referential integrity.

The table referenced by an referential integrity constraint.
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.