diff options
| author | Bruce Momjian <bruce@momjian.us> | 2003-03-20 18:52:48 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2003-03-20 18:52:48 +0000 |
| commit | 432b9b0f7576253aed760a39cf894dae9bc50ece (patch) | |
| tree | c1abf8469ec724e54ac9d550b014b60cbc245fdf /doc/src | |
| parent | db5d7ccac99e4b1f3ea0d09f7fc1b6f0682f336d (diff) | |
Add ALTER TABLE <tablename> CLUSTER ON <indexname>
Alvaro Herrera
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 23 |
1 files changed, 22 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 2b084456013..06c9653e226 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.56 2003/02/19 04:06:28 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.57 2003/03/20 18:52:47 momjian Exp $ PostgreSQL documentation --> @@ -46,6 +46,8 @@ ALTER TABLE [ ONLY ] <replaceable class="PARAMETER">table</replaceable> [ * ] DROP CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable> [ RESTRICT | CASCADE ] ALTER TABLE <replaceable class="PARAMETER">table</replaceable> OWNER TO <replaceable class="PARAMETER">new_owner</replaceable> +ALTER TABLE <replaceable class="PARAMETER">table</replaceable> + CLUSTER ON <replaceable class="PARAMETER">index_name</replaceable> </synopsis> <refsect2 id="R2-SQL-ALTERTABLE-1"> @@ -139,6 +141,15 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> </varlistentry> <varlistentry> + <term><replaceable class="PARAMETER"> index_name </replaceable></term> + <listitem> + <para> + The index name on which the table should be marked for clustering. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term>CASCADE</term> <listitem> <para> @@ -344,6 +355,16 @@ ALTER TABLE <replaceable class="PARAMETER">table</replaceable> </listitem> </varlistentry> + <varlistentry> + <term>CLUSTER</term> + <listitem> + <para> + This form marks a table for future <xref linkend="SQL-CLUSTER" endterm="sql-cluster-title"> + operations. + </para> + </listitem> + </varlistentry> + </variablelist> <para> |