diff options
author | Nathan Bossart <nathan@postgresql.org> | 2025-04-30 13:07:51 -0500 |
---|---|---|
committer | Nathan Bossart <nathan@postgresql.org> | 2025-04-30 13:07:51 -0500 |
commit | f60420cff66a9089a9b431f9c07f4a29aae4990a (patch) | |
tree | db2d15e3d08d54245e5382e475e5fe6c35055f92 /doc/src | |
parent | 368c3fbf9da96787d4e7cae61e11518d72f75071 (diff) | |
download | postgresql-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.sgml | 83 | ||||
-rw-r--r-- | doc/src/sgml/ref/pg_dumpall.sgml | 136 |
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> |