Index: doc/src/sgml/func.sgml
===================================================================
RCS file: /projects/cvsroot/pgsql-server/doc/src/sgml/func.sgml,v
retrieving revision 1.142
diff -c -r1.142 func.sgml
*** doc/src/sgml/func.sgml 2003/03/03 03:31:23 1.142
--- doc/src/sgml/func.sgml 2003/03/11 05:46:48
***************
*** 6804,6809 ****
--- 6804,6813 ----
+ pg_get_triggerdef
+
+
+
pg_get_constraintdef
***************
*** 6816,6828 ****
extract information from the system catalogs.
pg_get_viewdef(),
pg_get_ruledef(),
! pg_get_indexdef(), and
pg_get_constraintdef() respectively
reconstruct the creating command for a view, rule, index, or
constraint. (Note that this is a decompiled reconstruction, not
! the verbatim text of the command.) At present
! pg_get_constraintdef() only works for
! foreign-key constraints. pg_get_userbyid()
extracts a user's name given a usesysid
value.
--- 6820,6832 ----
extract information from the system catalogs.
pg_get_viewdef(),
pg_get_ruledef(),
! pg_get_indexdef(),
! pg_get_triggerdef(), and
pg_get_constraintdef() respectively
reconstruct the creating command for a view, rule, index, or
constraint. (Note that this is a decompiled reconstruction, not
! the verbatim text of the command.)
! pg_get_userbyid()
extracts a user's name given a usesysid
value.
***************
*** 6854,6859 ****
--- 6858,6868 ----
pg_get_indexdef(indexOID)
text
Get CREATE INDEX> command for index
+
+
+ pg_get_triggerdef(triggerOID)
+ text
+ Get CREATE [ CONSTRAINT ] TRIGGER> command for trigger
pg_get_constraintdef(constraintOID)