pg_trigger

The pg_trigger system catalog table stores triggers on tables.

Note

Greenplum Database does not support triggers.

column	type	references	description
oid	oid		The object ID
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	smallint		Bit mask identifying trigger conditions.
tgenabled	char		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 Note that Greenplum Database does not enforce referential integrity.	The table referenced by an 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	smallint		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.
tgoldtable	name		The name of the old transition table, or NULL if none.
tgnewtable	name		The name of the new transition table, or NULL if none.

Parent topic: System Catalogs Definitions