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

Commit4d6a854

Browse files
committed
Put new command-line options into alphabetical order
1 parent12b9aff commit4d6a854

File tree

5 files changed

+33
-33
lines changed

5 files changed

+33
-33
lines changed

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

Lines changed: 15 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -804,6 +804,21 @@ PostgreSQL documentation
804804
</listitem>
805805
</varlistentry>
806806

807+
<varlistentry>
808+
<term><option>--load-via-partition-root</option></term>
809+
<listitem>
810+
<para>
811+
When dumping a <command>COPY</command> or <command>INSERT</command> statement for a partitioned table,
812+
target the root of the partitioning hierarchy which contains it rather
813+
than the partition itself. This may be useful when reloading data on
814+
a server where rows do not always fall into the same partitions as
815+
they did on the original server. This could happen, for example, if
816+
the partitioning column is of type text and the two system have
817+
different definitions of the collation used to partition the data.
818+
</para>
819+
</listitem>
820+
</varlistentry>
821+
807822
<varlistentry>
808823
<term><option>--no-comments</option></term>
809824
<listitem>
@@ -912,21 +927,6 @@ PostgreSQL documentation
912927
</listitem>
913928
</varlistentry>
914929

915-
<varlistentry>
916-
<term><option>--load-via-partition-root</option></term>
917-
<listitem>
918-
<para>
919-
When dumping a COPY or INSERT statement for a partitioned table,
920-
target the root of the partitioning hierarchy which contains it rather
921-
than the partition itself. This may be useful when reloading data on
922-
a server where rows do not always fall into the same partitions as
923-
they did on the original server. This could happen, for example, if
924-
the partitioning column is of type text and the two system have
925-
different definitions of the collation used to partition the data.
926-
</para>
927-
</listitem>
928-
</varlistentry>
929-
930930
<varlistentry>
931931
<term><option>--section=<replaceable class="parameter">sectionname</replaceable></option></term>
932932
<listitem>

‎doc/src/sgml/ref/pg_dumpall.sgml

Lines changed: 15 additions & 15 deletions
Original file line numberDiff line numberDiff line change
@@ -342,6 +342,21 @@ PostgreSQL documentation
342342
</listitem>
343343
</varlistentry>
344344

345+
<varlistentry>
346+
<term><option>--load-via-partition-root</option></term>
347+
<listitem>
348+
<para>
349+
When dumping a <command>COPY</command> or <command>INSERT</command> statement for a partitioned table,
350+
target the root of the partitioning hierarchy which contains it rather
351+
than the partition itself. This may be useful when reloading data on
352+
a server where rows do not always fall into the same partitions as
353+
they did on the original server. This could happen, for example, if
354+
the partitioning column is of type text and the two system have
355+
different definitions of the collation used to partition the data.
356+
</para>
357+
</listitem>
358+
</varlistentry>
359+
345360
<varlistentry>
346361
<term><option>--no-comments</option></term>
347362
<listitem>
@@ -449,21 +464,6 @@ PostgreSQL documentation
449464
</listitem>
450465
</varlistentry>
451466

452-
<varlistentry>
453-
<term><option>--load-via-partition-root</option></term>
454-
<listitem>
455-
<para>
456-
When dumping a COPY or INSERT statement for a partitioned table,
457-
target the root of the partitioning hierarchy which contains it rather
458-
than the partition itself. This may be useful when reloading data on
459-
a server where rows do not always fall into the same partitions as
460-
they did on the original server. This could happen, for example, if
461-
the partitioning column is of type text and the two system have
462-
different definitions of the collation used to partition the data.
463-
</para>
464-
</listitem>
465-
</varlistentry>
466-
467467
<varlistentry>
468468
<term><option>--use-set-session-authorization</option></term>
469469
<listitem>

‎src/bin/pg_dump/pg_dump.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -981,6 +981,7 @@ help(const char *progname)
981981
printf(_(" --exclude-table-data=TABLE do NOT dump data for the named table(s)\n"));
982982
printf(_(" --if-exists use IF EXISTS when dropping objects\n"));
983983
printf(_(" --inserts dump data as INSERT commands, rather than COPY\n"));
984+
printf(_(" --load-via-partition-root load partitions via the root table\n"));
984985
printf(_(" --no-comments do not dump comments\n"));
985986
printf(_(" --no-publications do not dump publications\n"));
986987
printf(_(" --no-security-labels do not dump security label assignments\n"));
@@ -989,7 +990,6 @@ help(const char *progname)
989990
printf(_(" --no-tablespaces do not dump tablespace assignments\n"));
990991
printf(_(" --no-unlogged-table-data do not dump unlogged table data\n"));
991992
printf(_(" --quote-all-identifiers quote all identifiers, even if not key words\n"));
992-
printf(_(" --load-via-partition-root load partitions via the root table\n"));
993993
printf(_(" --section=SECTION dump named section (pre-data, data, or post-data)\n"));
994994
printf(_(" --serializable-deferrable wait until the dump can run without anomalies\n"));
995995
printf(_(" --snapshot=SNAPSHOT use given snapshot for the dump\n"));

‎src/bin/pg_dump/pg_dumpall.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -612,6 +612,7 @@ help(void)
612612
printf(_(" --disable-triggers disable triggers during data-only restore\n"));
613613
printf(_(" --if-exists use IF EXISTS when dropping objects\n"));
614614
printf(_(" --inserts dump data as INSERT commands, rather than COPY\n"));
615+
printf(_(" --load-via-partition-root load partitions via the root table\n"));
615616
printf(_(" --no-comments do not dump comments\n"));
616617
printf(_(" --no-publications do not dump publications\n"));
617618
printf(_(" --no-role-passwords do not dump passwords for roles\n"));
@@ -621,7 +622,6 @@ help(void)
621622
printf(_(" --no-tablespaces do not dump tablespace assignments\n"));
622623
printf(_(" --no-unlogged-table-data do not dump unlogged table data\n"));
623624
printf(_(" --quote-all-identifiers quote all identifiers, even if not key words\n"));
624-
printf(_(" --load-via-partition-root load partitions via the root table\n"));
625625
printf(_(" --use-set-session-authorization\n"
626626
" use SET SESSION AUTHORIZATION commands instead of\n"
627627
" ALTER OWNER commands to set ownership\n"));

‎src/bin/pg_dump/pg_restore.c

Lines changed: 1 addition & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -483,9 +483,9 @@ usage(const char *progname)
483483
printf(_(" --disable-triggers disable triggers during data-only restore\n"));
484484
printf(_(" --enable-row-security enable row security\n"));
485485
printf(_(" --if-exists use IF EXISTS when dropping objects\n"));
486+
printf(_(" --no-comments do not dump comments\n"));
486487
printf(_(" --no-data-for-failed-tables do not restore data of tables that could not be\n"
487488
" created\n"));
488-
printf(_(" --no-comments do not dump comments\n"));
489489
printf(_(" --no-publications do not restore publications\n"));
490490
printf(_(" --no-security-labels do not restore security labels\n"));
491491
printf(_(" --no-subscriptions do not restore subscriptions\n"));

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp