Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




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.

  Published courtesy of The PostgreSQL Global Development Group Design by Interspire