11<!--
2- $Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.13 2002/09/21 18:32:54 petere Exp $
2+ $Header: /cvsroot/pgsql/doc/src/sgml/ref/reindex.sgml,v 1.14 2002/11/17 23:43:32 momjian Exp $
33PostgreSQL documentation
44-->
55
@@ -21,7 +21,7 @@ PostgreSQL documentation
2121 <date>2000-03-30</date>
2222 </refsynopsisdivinfo>
2323 <synopsis>
24- REINDEX {TABLE |DATABASE | INDEX } <replaceable class="PARAMETER">name</replaceable> [ FORCE ]
24+ REINDEX {DATABASE |TABLE | INDEX } <replaceable class="PARAMETER">name</replaceable> [ FORCE ]
2525 </synopsis>
2626
2727 <refsect2 id="R2-SQL-REINDEX-1">
@@ -35,19 +35,19 @@ REINDEX { TABLE | DATABASE | INDEX } <replaceable class="PARAMETER">name</replac
3535
3636 <variablelist>
3737 <varlistentry>
38- <term>TABLE </term>
38+ <term>DATABASE </term>
3939 <listitem>
4040 <para>
41- Recreate all indexes of a specified table.
41+ Recreate all system indexes of a specified database.
42+ (User-table indexes are not included.)
4243 </para>
4344 </listitem>
4445 </varlistentry>
4546 <varlistentry>
46- <term>DATABASE </term>
47+ <term>TABLE </term>
4748 <listitem>
4849 <para>
49- Recreate all system indexes of a specified database.
50- (User-table indexes are not included.)
50+ Recreate all indexes of a specified table.
5151 </para>
5252 </listitem>
5353 </varlistentry>
@@ -63,7 +63,7 @@ REINDEX { TABLE | DATABASE | INDEX } <replaceable class="PARAMETER">name</replac
6363 <term><replaceable class="PARAMETER">name</replaceable></term>
6464 <listitem>
6565 <para>
66- The name of the specifictable/ database/index to be reindexed.
66+ The name of the specific database/table /index to be reindexed.
6767Table and index names may be schema-qualified.
6868 </para>
6969 </listitem>
@@ -156,8 +156,8 @@ REINDEX
156156 started instead, giving it
157157 the command-line options -O and -P (these options allow system table
158158 modifications and prevent use of system indexes, respectively). Then
159- issue <command>REINDEXINDEX </>, <command>REINDEX TABLE</>,or
160- <command>REINDEXDATABASE </> depending on how much you want to reconstruct.
159+ issue <command>REINDEXDATABASE </>, <command>REINDEX TABLE</>,
160+ <command>REINDEXINDEX </>, or depending on how much you want to reconstruct.
161161 If in doubt, use <command>REINDEX DATABASE FORCE</> to force reconstruction
162162 of all system indexes in the database. Then quit the standalone backend
163163 and restart the postmaster.