diff options
| author | Peter Eisentraut <peter_e@gmx.net> | 2009-10-09 21:02:56 +0000 |
|---|---|---|
| committer | Peter Eisentraut <peter_e@gmx.net> | 2009-10-09 21:02:56 +0000 |
| commit | b865d2758255b767e30dc5f23c7c7d209e716f3b (patch) | |
| tree | 7df91d80adfc7de9040c7446ea87d319a2e18a57 /doc/src | |
| parent | c970292a94e0fff468d500db430d751b6221a0b4 (diff) | |
| download | postgresql-b865d2758255b767e30dc5f23c7c7d209e716f3b.tar.gz postgresql-b865d2758255b767e30dc5f23c7c7d209e716f3b.zip | |
Use pg_get_triggerdef in pg_dump
Add a variant of pg_get_triggerdef with a second argument "pretty" that
causes the output to be formatted in the way pg_dump used to do. Use this
variant in pg_dump with server versions >= 8.5.
This insulates pg_dump from most future trigger feature additions, such as
the upcoming column triggers patch.
Author: Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 7 |
1 files changed, 6 insertions, 1 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index 29d821e01a2..da558668c8a 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -1,4 +1,4 @@ -<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.487 2009/08/16 19:55:21 tgl Exp $ --> +<!-- $PostgreSQL: pgsql/doc/src/sgml/func.sgml,v 1.488 2009/10/09 21:02:55 petere Exp $ --> <chapter id="functions"> <title>Functions and Operators</title> @@ -12370,6 +12370,11 @@ SELECT pg_type_is_visible('myschema.widget'::regtype); <entry>get <command>CREATE [ CONSTRAINT ] TRIGGER</> command for trigger</entry> </row> <row> + <entry><function>pg_get_triggerdef</function>(<parameter>trigger_oid</parameter>, <parameter>pretty_bool</>)</entry> + <entry><type>text</type></entry> + <entry>get <command>CREATE [ CONSTRAINT ] TRIGGER</> command for trigger</entry> + </row> + <row> <entry><literal><function>pg_get_userbyid</function>(<parameter>role_oid</parameter>)</literal></entry> <entry><type>name</type></entry> <entry>get role name with given OID</entry> |