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)