diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2004-10-21 22:48:54 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2004-10-21 22:48:54 +0000 |
| commit | 9eff02f5ac374466e37d63ed4361496a4aeef0d6 (patch) | |
| tree | e899a2a196fdd37974c6f03b83b107f36b64456f /doc/src | |
| parent | 12a47c6aca43e33d42ef946761ec0406476dd1b0 (diff) | |
| download | postgresql-9eff02f5ac374466e37d63ed4361496a4aeef0d6.tar.gz postgresql-9eff02f5ac374466e37d63ed4361496a4aeef0d6.zip | |
Update obsolete comments about COPY vs INSERT options, per Uwe Schroeder.
Diffstat (limited to 'doc/src')
| -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 72ec981fcc5..a35fb491466 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.73 2004/07/13 02:59:49 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.74 2004/10/21 22:48:54 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> |