Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commit9eff02f

Browse files
committed
Update obsolete comments about COPY vs INSERT options, per Uwe Schroeder.
1 parent12a47c6 commit9eff02f

File tree

1 file changed

+9
-6
lines changed

1 file changed

+9
-6
lines changed

‎doc/src/sgml/ref/pg_dump.sgml

Lines changed: 9 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.73 2004/07/13 02:59:49 momjian Exp $
2+
$PostgreSQL: pgsql/doc/src/sgml/ref/pg_dump.sgml,v 1.74 2004/10/21 22:48:54 tgl Exp $
33
PostgreSQL documentation
44
-->
55

@@ -175,9 +175,11 @@ PostgreSQL documentation
175175
<listitem>
176176
<para>
177177
Dump data as <command>INSERT</command> commands (rather
178-
than <command>COPY</command>). This will make restoration very
179-
slow, but it makes the archives more portable to other SQL database
180-
management systems.
178+
than <command>COPY</command>). This will make restoration very slow;
179+
it is mainly useful for making dumps that can be loaded into
180+
non-<productname>PostgreSQL</productname> databases. Note that
181+
the restore may fail altogether if you have rearranged column order.
182+
The <option>-D</option> option is safer, though even slower.
181183
</para>
182184
</listitem>
183185
</varlistentry>
@@ -192,8 +194,9 @@ PostgreSQL documentation
192194
column names (<literal>INSERT INTO
193195
<replaceable>table</replaceable>
194196
(<replaceable>column</replaceable>, ...) VALUES
195-
...</literal>). This will make restoration very slow,
196-
but it is necessary if you desire to rearrange the column ordering.
197+
...</literal>). This will make restoration very slow; it is mainly
198+
useful for making dumps that can be loaded into
199+
non-<productname>PostgreSQL</productname> databases.
197200
</para>
198201
</listitem>
199202
</varlistentry>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp