10BC0 Put new command-line options into alphabetical order · postgrespro/postgres_cluster@4d6a854 · GitHub
[go: up one dir, main page]
Skip to content

Commit 4d6a854

Browse files
peterepetere
committed
Put new command-line options into alphabetical order
1 parent 12b9aff commit 4d6a854

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)
0