diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-10-21 22:49:04 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-10-21 22:49:04 +0000 |
| commit | 25d1755a29ec77facafff42920403df13f218c96 (patch) | |
| tree | 809f046738782006057519420f60e838683e6f81 | |
| parent | d06384c6d75742f88d4b1e21e68b28dc71116320 (diff) | |
| download | postgresql-25d1755a29ec77facafff42920403df13f218c96.tar.gz postgresql-25d1755a29ec77facafff42920403df13f218c96.zip | |
Update obsolete comments about COPY vs INSERT options, per Uwe Schroeder.
| -rw-r--r-- | doc/src/sgml/ref/pg_dump.sgml | 15 |
1 files changed, 9 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 986a571b80f..06d9c68ae0e 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.65.2.1 2003/11/04 09:45:30 petere Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.65.2.2 2004/10/21 22:49:04 tgl Exp $ PostgreSQL documentation --> @@ -175,9 +175,11 @@ PostgreSQL documentation <listitem> <para> Dump data as <command>INSERT</command> commands (rather - than <command>COPY</command>). This will make restoration very - slow, but it makes the archives more portable to other SQL database - management systems. + than <command>COPY</command>). This will make restoration very slow; + it is mainly useful for making dumps that can be loaded into + non-<productname>PostgreSQL</productname> databases. Note that + the restore may fail altogether if you have rearranged column order. + The <option>-D</option> option is safer, though even slower. </para> </listitem> </varlistentry> @@ -192,8 +194,9 @@ PostgreSQL documentation column names (<literal>INSERT INTO <replaceable>table</replaceable> (<replaceable>column</replaceable>, ...) VALUES - ...</literal>). This will make restoration very slow, - but it is necessary if you desire to rearrange the column ordering. + ...</literal>). This will make restoration very slow; it is mainly + useful for making dumps that can be loaded into + non-<productname>PostgreSQL</productname> databases. </para> </listitem> </varlistentry> |