PostgreSQL 8.1.3 Documentation
Prev	Fast Backward	Chapter 42. System Catalogs	Fast Forward	Next

42.32. `pg_trigger`

The catalog pg_trigger stores triggers on tables. See CREATE TRIGGER for more information.

Table 42-32. pg_trigger Columns

Name	Type	References	Description
`tgrelid`	`oid`	`pg_class.oid`	The table this trigger is on
`tgname`	`name`		Trigger name (must be unique among triggers of same table)
`tgfoid`	`oid`	`pg_proc.oid`	The function to be called
`tgtype`	`int2`		Bit mask identifying trigger conditions
`tgenabled`	`bool`		True if trigger is enabled
`tgisconstraint`	`bool`		True if trigger implements a referential integrity constraint
`tgconstrname`	`name`		Referential integrity constraint name
`tgconstrrelid`	`oid`	`pg_class.oid`	The table referenced by an referential integrity constraint
`tgdeferrable`	`bool`		True if deferrable
`tginitdeferred`	`bool`		True if initially deferred
`tgnargs`	`int2`		Number of argument strings passed to trigger function
`tgattr`	`int2vector`		Currently unused
`tgargs`	`bytea`		Argument strings to pass to trigger, each null-terminated

Note: pg_class.reltriggers needs to agree with the number of triggers found in this table for the given relation.

Prev	Home	Next
`pg_tablespace`	Up	`pg_type`

PostgreSQL Manual