aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorNathan Bossart <nathan@postgresql.org>2025-04-30 13:07:51 -0500
committerNathan Bossart <nathan@postgresql.org>2025-04-30 13:07:51 -0500
commitf60420cff66a9089a9b431f9c07f4a29aae4990a (patch)
treedb2d15e3d08d54245e5382e475e5fe6c35055f92 /doc/src
parent368c3fbf9da96787d4e7cae61e11518d72f75071 (diff)
downloadpostgresql-f60420cff66a9089a9b431f9c07f4a29aae4990a.tar.gz
postgresql-f60420cff66a9089a9b431f9c07f4a29aae4990a.zip
doc: Alphabetize long options for pg_dump[all].
The current ordering strategy for these pages is to list the short options in alphabetical order followed by the long options in alphabetical order. If an option has both a short variant and a long variant, the short variant takes precedence. This commit moves a few recently added options to match this style. We should probably adjust all pages and --help output to list the long and short options in one combined alphabetical list (with the long variants taking precedence), but that is a much larger change, so it is left as a future exercise. Oversights in commits a5cf808be5, 1fd1bd8710, and bde2fb797a. Reviewed-by: Álvaro Herrera <alvherre@kurilemu.de> Reviewed-by: Peter Eisentraut <peter@eisentraut.org> Discussion: https://postgr.es/m/aBFBtsltgu3-IU1d%40nathan
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/pg_dump.sgml83
-rw-r--r--doc/src/sgml/ref/pg_dumpall.sgml136
2 files changed, 109 insertions, 110 deletions
diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml
index b757d27ebd0..c10bca63e55 100644
--- a/doc/src/sgml/ref/pg_dump.sgml
+++ b/doc/src/sgml/ref/pg_dump.sgml
@@ -656,17 +656,6 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
- <term><option>--statistics-only</option></term>
- <listitem>
- <para>
- Dump only the statistics, not the schema (data definitions) or data.
- Statistics for tables, materialized views, and indexes are dumped.
- </para>
-
- </listitem>
- </varlistentry>
-
- <varlistentry>
<term><option>-Z <replaceable class="parameter">level</replaceable></option></term>
<term><option>-Z <replaceable class="parameter">method</replaceable></option>[:<replaceable>detail</replaceable>]</term>
<term><option>--compress=<replaceable class="parameter">level</replaceable></option></term>
@@ -1124,19 +1113,19 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
- <term><option>--no-security-labels</option></term>
+ <term><option>--no-schema</option></term>
<listitem>
<para>
- Do not dump security labels.
+ Do not dump schema (data definitions).
</para>
</listitem>
</varlistentry>
<varlistentry>
- <term><option>--no-schema</option></term>
+ <term><option>--no-security-labels</option></term>
<listitem>
<para>
- Do not dump schema (data definitions).
+ Do not dump security labels.
</para>
</listitem>
</varlistentry>
@@ -1233,33 +1222,6 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
- <term><option>--with-data</option></term>
- <listitem>
- <para>
- Dump data. This is the default.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><option>--with-schema</option></term>
- <listitem>
- <para>
- Dump schema (data definitions). This is the default.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><option>--with-statistics</option></term>
- <listitem>
- <para>
- Dump statistics. This is the default.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
<term><option>--on-conflict-do-nothing</option></term>
<listitem>
<para>
@@ -1393,6 +1355,16 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
+ <term><option>--statistics-only</option></term>
+ <listitem>
+ <para>
+ Dump only the statistics, not the schema (data definitions) or data.
+ Statistics for tables, materialized views, and indexes are dumped.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><option>--strict-names</option></term>
<listitem>
<para>
@@ -1468,6 +1440,33 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
+ <term><option>--with-data</option></term>
+ <listitem>
+ <para>
+ Dump data. This is the default.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><option>--with-schema</option></term>
+ <listitem>
+ <para>
+ Dump schema (data definitions). This is the default.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><option>--with-statistics</option></term>
+ <listitem>
+ <para>
+ Dump statistics. This is the default.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><option>-?</option></term>
<term><option>--help</option></term>
<listitem>
diff --git a/doc/src/sgml/ref/pg_dumpall.sgml b/doc/src/sgml/ref/pg_dumpall.sgml
index 43fdab2d77e..5df4b04287b 100644
--- a/doc/src/sgml/ref/pg_dumpall.sgml
+++ b/doc/src/sgml/ref/pg_dumpall.sgml
@@ -206,37 +206,6 @@ PostgreSQL documentation
</varlistentry>
<varlistentry>
- <term><option>--filter=<replaceable class="parameter">filename</replaceable></option></term>
- <listitem>
- <para>
- Specify a filename from which to read patterns for databases excluded
- from the dump. The patterns are interpreted according to the same rules
- as <option>--exclude-database</option>.
- To read from <literal>STDIN</literal>, use <filename>-</filename> as the
- filename. The <option>--filter</option> option can be specified in
- conjunction with <option>--exclude-database</option> for excluding
- databases, and can also be specified more than once for multiple filter
- files.
- </para>
-
- <para>
- The file lists one database pattern per row, with the following format:
-<synopsis>
-exclude database <replaceable class="parameter">PATTERN</replaceable>
-</synopsis>
- </para>
-
- <para>
- Lines starting with <literal>#</literal> are considered comments and
- ignored. Comments can be placed after an object pattern row as well.
- Blank lines are also ignored. See <xref linkend="app-psql-patterns"/>
- for how to perform quoting in patterns.
- </para>
-
- </listitem>
- </varlistentry>
-
- <varlistentry>
<term><option>-g</option></term>
<term><option>--globals-only</option></term>
<listitem>
@@ -346,16 +315,6 @@ exclude database <replaceable class="parameter">PATTERN</replaceable>
</varlistentry>
<varlistentry>
- <term><option>--statistics-only</option></term>
- <listitem>
- <para>
- Dump only the statistics, not the schema (data definitions) or data.
- Statistics for tables, materialized views, and indexes are dumped.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
<term><option>--binary-upgrade</option></term>
<listitem>
<para>
@@ -445,6 +404,37 @@ exclude database <replaceable class="parameter">PATTERN</replaceable>
</varlistentry>
<varlistentry>
+ <term><option>--filter=<replaceable class="parameter">filename</replaceable></option></term>
+ <listitem>
+ <para>
+ Specify a filename from which to read patterns for databases excluded
+ from the dump. The patterns are interpreted according to the same rules
+ as <option>--exclude-database</option>.
+ To read from <literal>STDIN</literal>, use <filename>-</filename> as the
+ filename. The <option>--filter</option> option can be specified in
+ conjunction with <option>--exclude-database</option> for excluding
+ databases, and can also be specified more than once for multiple filter
+ files.
+ </para>
+
+ <para>
+ The file lists one database pattern per row, with the following format:
+<synopsis>
+exclude database <replaceable class="parameter">PATTERN</replaceable>
+</synopsis>
+ </para>
+
+ <para>
+ Lines starting with <literal>#</literal> are considered comments and
+ ignored. Comments can be placed after an object pattern row as well.
+ Blank lines are also ignored. See <xref linkend="app-psql-patterns"/>
+ for how to perform quoting in patterns.
+ </para>
+
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><option>--if-exists</option></term>
<listitem>
<para>
@@ -641,33 +631,6 @@ exclude database <replaceable class="parameter">PATTERN</replaceable>
</varlistentry>
<varlistentry>
- <term><option>--with-data</option></term>
- <listitem>
- <para>
- Dump data. This is the default.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><option>--with-schema</option></term>
- <listitem>
- <para>
- Dump schema (data definitions). This is the default.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
- <term><option>--with-statistics</option></term>
- <listitem>
- <para>
- Dump statistics. This is the default.
- </para>
- </listitem>
- </varlistentry>
-
- <varlistentry>
<term><option>--no-unlogged-table-data</option></term>
<listitem>
<para>
@@ -723,6 +686,16 @@ exclude database <replaceable class="parameter">PATTERN</replaceable>
</varlistentry>
<varlistentry>
+ <term><option>--statistics-only</option></term>
+ <listitem>
+ <para>
+ Dump only the statistics, not the schema (data definitions) or data.
+ Statistics for tables, materialized views, and indexes are dumped.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><option>--use-set-session-authorization</option></term>
<listitem>
<para>
@@ -736,6 +709,33 @@ exclude database <replaceable class="parameter">PATTERN</replaceable>
</varlistentry>
<varlistentry>
+ <term><option>--with-data</option></term>
+ <listitem>
+ <para>
+ Dump data. This is the default.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><option>--with-schema</option></term>
+ <listitem>
+ <para>
+ Dump schema (data definitions). This is the default.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
+ <term><option>--with-statistics</option></term>
+ <listitem>
+ <para>
+ Dump statistics. This is the default.
+ </para>
+ </listitem>
+ </varlistentry>
+
+ <varlistentry>
<term><option>-?</option></term>
<term><option>--help</option></term>
<listitem>