diff options
Diffstat (limited to 'doc/src/sgml/ref/alter_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/alter_table.sgml | 24 |
1 files changed, 23 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index ee501a1a37..ef8e803d6f 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.85 2006/07/02 01:58:36 momjian Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_table.sgml,v 1.86 2006/07/02 02:23:17 momjian Exp $ PostgreSQL documentation --> @@ -46,6 +46,8 @@ where <replaceable class="PARAMETER">action</replaceable> is one of: CLUSTER ON <replaceable class="PARAMETER">index_name</replaceable> SET WITHOUT CLUSTER SET WITHOUT OIDS + SET (FILLFACTOR = <replaceable class="PARAMETER">fillfactor</replaceable>) + RESET (FILLFACTOR) INHERIT <replaceable class="PARAMETER">parent_table</replaceable> NO INHERIT <replaceable class="PARAMETER">parent_table</replaceable> OWNER TO <replaceable class="PARAMETER">new_owner</replaceable> @@ -322,6 +324,26 @@ where <replaceable class="PARAMETER">action</replaceable> is one of: </varlistentry> <varlistentry> + <term><literal>SET (FILLFACTOR)</literal></term> + <listitem> + <para> + This form changes the table's fillfactor to the specified percentage. + Table structure is not modified immediately; use <literal>CLUSTER</literal> + to ensure reflection of the change. + </para> + </listitem> + </varlistentry> + + <varlistentry> + <term><literal>RESET</literal></term> + <listitem> + <para> + This form changes the table's fillfactor to the default value. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>RENAME</literal></term> <listitem> <para> |