aboutsummaryrefslogtreecommitdiff
path: root/doc/src
diff options
context:
space:
mode:
authorMagnus Hagander <magnus@hagander.net>2013-01-17 11:24:47 +0100
committerMagnus Hagander <magnus@hagander.net>2013-01-17 11:24:47 +0100
commitf3af53441ed0b306692a1cc31003a84d1b5b3cf7 (patch)
treed21b2e0fd1885497eabb8fd294e652cf856b4ad0 /doc/src
parent36bdfa52a0780d2fcbb48665ab7ca98a13593fdf (diff)
downloadpostgresql-f3af53441ed0b306692a1cc31003a84d1b5b3cf7.tar.gz
postgresql-f3af53441ed0b306692a1cc31003a84d1b5b3cf7.zip
Support multiple -t/--table arguments for more commands
On top of the previous support in pg_dump, add support to specify multiple tables (by using the -t option multiple times) to pg_restore, clsuterdb, reindexdb and vacuumdb. Josh Kupershmidt, reviewed by Karl O. Pinc
Diffstat (limited to 'doc/src')
-rw-r--r--doc/src/sgml/ref/clusterdb.sgml14
-rw-r--r--doc/src/sgml/ref/pg_restore.sgml3
-rw-r--r--doc/src/sgml/ref/reindexdb.sgml39
-rw-r--r--doc/src/sgml/ref/vacuumdb.sgml20
4 files changed, 53 insertions, 23 deletions
diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml
index 097ea912f1c..13169324500 100644
--- a/doc/src/sgml/ref/clusterdb.sgml
+++ b/doc/src/sgml/ref/clusterdb.sgml
@@ -24,7 +24,17 @@ PostgreSQL documentation
<command>clusterdb</command>
<arg rep="repeat"><replaceable>connection-option</replaceable></arg>
<group choice="opt"><arg choice="plain"><option>--verbose</option></arg><arg choice="plain"><option>-v</option></arg></group>
- <arg choice="opt"><group choice="plain"><arg choice="plain"><option>--table</option></arg><arg choice="plain"><option>-t</option></arg></group> <replaceable>table</replaceable> </arg>
+
+ <arg choice="plain" rep="repeat">
+ <arg choice="opt">
+ <group choice="plain">
+ <arg choice="plain"><option>--table</option></arg>
+ <arg choice="plain"><option>-t</option></arg>
+ </group>
+ <replaceable>table</replaceable>
+ </arg>
+ </arg>
+
<arg choice="opt"><replaceable>dbname</replaceable></arg>
</cmdsynopsis>
@@ -117,6 +127,8 @@ PostgreSQL documentation
<listitem>
<para>
Cluster <replaceable class="parameter">table</replaceable> only.
+ Multiple tables can be clustered by writing multiple
+ <option>-t</> switches.
</para>
</listitem>
</varlistentry>
diff --git a/doc/src/sgml/ref/pg_restore.sgml b/doc/src/sgml/ref/pg_restore.sgml
index f4668e73f6d..0d73294930f 100644
--- a/doc/src/sgml/ref/pg_restore.sgml
+++ b/doc/src/sgml/ref/pg_restore.sgml
@@ -400,7 +400,8 @@
<term><option>--table=<replaceable class="parameter">table</replaceable></option></term>
<listitem>
<para>
- Restore definition and/or data of named table only. This can be
+ Restore definition and/or data of named table only. Multiple tables
+ may be specified with multiple <option>-t</> switches. This can be
combined with the <option>-n</option> option to specify a schema.
</para>
</listitem>
diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml
index 781012f3c58..3ba9951df8e 100644
--- a/doc/src/sgml/ref/reindexdb.sgml
+++ b/doc/src/sgml/ref/reindexdb.sgml
@@ -23,20 +23,27 @@ PostgreSQL documentation
<cmdsynopsis>
<command>reindexdb</command>
<arg rep="repeat"><replaceable>connection-option</replaceable></arg>
- <group choice="opt">
- <group choice="plain">
- <arg choice="plain"><option>--table</option></arg>
- <arg choice="plain"><option>-t</option></arg>
- </group>
- <replaceable>table</replaceable>
- </group>
- <group choice="opt">
- <group choice="plain">
- <arg choice="plain"><option>--index</option></arg>
- <arg choice="plain"><option>-i</option></arg>
- </group>
- <replaceable>index</replaceable>
- </group>
+
+ <arg choice="plain" rep="repeat">
+ <arg choice="opt">
+ <group choice="plain">
+ <arg choice="plain"><option>--table</option></arg>
+ <arg choice="plain"><option>-t</option></arg>
+ </group>
+ <replaceable>table</replaceable>
+ </arg>
+ </arg>
+
+ <arg choice="plain" rep="repeat">
+ <arg choice="opt">
+ <group choice="plain">
+ <arg choice="plain"><option>--index</option></arg>
+ <arg choice="plain"><option>-i</option></arg>
+ </group>
+ <replaceable>index</replaceable>
+ </arg>
+ </arg>
+
<arg choice="opt"><replaceable>dbname</replaceable></arg>
</cmdsynopsis>
@@ -128,6 +135,8 @@ PostgreSQL documentation
<listitem>
<para>
Recreate <replaceable class="parameter">index</replaceable> only.
+ Multiple indexes can be recreated by writing multiple
+ <option>-i</> switches.
</para>
</listitem>
</varlistentry>
@@ -158,6 +167,8 @@ PostgreSQL documentation
<listitem>
<para>
Reindex <replaceable class="parameter">table</replaceable> only.
+ Multiple tables can be reindexed by writing multiple
+ <option>-t</> switches.
</para>
</listitem>
</varlistentry>
diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml
index c60ba4424fe..a5216ec0389 100644
--- a/doc/src/sgml/ref/vacuumdb.sgml
+++ b/doc/src/sgml/ref/vacuumdb.sgml
@@ -24,14 +24,18 @@ PostgreSQL documentation
<command>vacuumdb</command>
<arg rep="repeat"><replaceable>connection-option</replaceable></arg>
<arg rep="repeat"><replaceable>option</replaceable></arg>
- <arg choice="opt">
- <group choice="plain">
- <arg choice="plain"><option>--table</option></arg>
- <arg choice="plain"><option>-t</option></arg>
- </group>
- <replaceable>table</replaceable>
- <arg choice="opt">( <replaceable class="parameter">column</replaceable> [,...] )</arg>
+
+ <arg choice="plain" rep="repeat">
+ <arg choice="opt">
+ <group choice="plain">
+ <arg choice="plain"><option>--table</option></arg>
+ <arg choice="plain"><option>-t</option></arg>
+ </group>
+ <replaceable>table</replaceable>
+ <arg choice="opt">( <replaceable class="parameter">column</replaceable> [,...] )</arg>
+ </arg>
</arg>
+
<arg choice="opt"><replaceable>dbname</replaceable></arg>
</cmdsynopsis>
@@ -147,6 +151,8 @@ PostgreSQL documentation
Clean or analyze <replaceable class="parameter">table</replaceable> only.
Column names can be specified only in conjunction with
the <option>--analyze</option> or <option>--analyze-only</option> options.
+ Multiple tables can be vacuumed by writing multiple
+ <option>-t</> switches.
</para>
<tip>
<para>