pg_trigger

The pg_trigger system catalog table stores triggers on tables.

Note: Greenplum Database does not support triggers.

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.

Parent topic: System Catalogs Definitions