diff options
| author | Nathan Bossart <nathan@postgresql.org> | 2024-03-11 10:33:36 -0500 |
|---|---|---|
| committer | Nathan Bossart <nathan@postgresql.org> | 2024-03-11 10:33:36 -0500 |
| commit | 648928c79bed975a89fa2e4ef8bc0bade8e0e0d8 (patch) | |
| tree | bb97a3bb3ce0ffbb336aac65c793b4e5b86a4caa /doc/src | |
| parent | 674e49c73c1c442d05a46388fcc1431fbd59ca44 (diff) | |
| download | postgresql-648928c79bed975a89fa2e4ef8bc0bade8e0e0d8.tar.gz postgresql-648928c79bed975a89fa2e4ef8bc0bade8e0e0d8.zip | |
vacuumdb: Allow specifying objects to process in all databases.
Presently, vacuumdb's --table, --schema, and --exclude-schema
options cannot be used together with --all, i.e., you cannot
specify tables or schemas to process in all databases. This commit
removes this unnecessary restriction, thus enabling potentially
useful commands like "vacuumdb --all --schema pg_catalog".
Reviewed-by: Kyotaro Horiguchi, Dean Rasheed
Discussion: https://postgr.es/m/20230628232402.GA1954626%40nathanxps13
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/vacuumdb.sgml | 60 |
1 files changed, 35 insertions, 25 deletions
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 09356ea4fae..66fccb30a2d 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -36,7 +36,13 @@ PostgreSQL documentation </arg> </arg> - <arg choice="opt"><replaceable>dbname</replaceable></arg> + <arg choice="opt"> + <group choice="plain"> + <arg choice="plain"><replaceable>dbname</replaceable></arg> + <arg choice="plain"><option>-a</option></arg> + <arg choice="plain"><option>--all</option></arg> + </group> + </arg> </cmdsynopsis> <cmdsynopsis> @@ -47,40 +53,44 @@ PostgreSQL documentation <arg choice="plain" rep="repeat"> <arg choice="opt"> <group choice="plain"> - <arg choice="plain"> - <arg choice="opt"> - <group choice="plain"> - <arg choice="plain"><option>-n</option></arg> - <arg choice="plain"><option>--schema</option></arg> - </group> - <replaceable>schema</replaceable> - </arg> - </arg> - - <arg choice="plain"> - <arg choice="opt"> - <group choice="plain"> - <arg choice="plain"><option>-N</option></arg> - <arg choice="plain"><option>--exclude-schema</option></arg> - </group> - <replaceable>schema</replaceable> - </arg> - </arg> + <arg choice="plain"><option>-n</option></arg> + <arg choice="plain"><option>--schema</option></arg> </group> + <replaceable>schema</replaceable> </arg> </arg> - <arg choice="opt"><replaceable>dbname</replaceable></arg> + <arg choice="opt"> + <group choice="plain"> + <arg choice="plain"><replaceable>dbname</replaceable></arg> + <arg choice="plain"><option>-a</option></arg> + <arg choice="plain"><option>--all</option></arg> + </group> + </arg> </cmdsynopsis> <cmdsynopsis> <command>vacuumdb</command> <arg rep="repeat"><replaceable>connection-option</replaceable></arg> <arg rep="repeat"><replaceable>option</replaceable></arg> - <group choice="plain"> - <arg choice="plain"><option>-a</option></arg> - <arg choice="plain"><option>--all</option></arg> - </group> + + <arg choice="plain" rep="repeat"> + <arg choice="opt"> + <group choice="plain"> + <arg choice="plain"><option>-N</option></arg> + <arg choice="plain"><option>--exclude-schema</option></arg> + </group> + <replaceable>schema</replaceable> + </arg> + </arg> + + <arg choice="opt"> + <group choice="plain"> + <arg choice="plain"><replaceable>dbname</replaceable></arg> + <arg choice="plain"><option>-a</option></arg> + <arg choice="plain"><option>--all</option></arg> + </group> + </arg> </cmdsynopsis> </refsynopsisdiv> |