diff options
| author | Bruce Momjian <bruce@momjian.us> | 2006-07-02 02:23:23 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2006-07-02 02:23:23 +0000 |
| commit | 277807bd9eba1645d8dfc9252fa29220c4a83751 (patch) | |
| tree | fb3dca975d8371bd42e9e58d0b841db3fd6c4654 /doc/src/sgml/ref/create_table.sgml | |
| parent | 5d5c1416bf03efcf13cfd3b8f68a0bba199d70af (diff) | |
| download | postgresql-277807bd9eba1645d8dfc9252fa29220c4a83751.tar.gz | |
Add FILLFACTOR to CREATE INDEX.
ITAGAKI Takahiro
Diffstat (limited to 'doc/src/sgml/ref/create_table.sgml')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 12 |
1 files changed, 11 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 0276dc7ad2..c40c37c19c 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.102 2006/06/28 22:01:52 neilc Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/create_table.sgml,v 1.103 2006/07/02 02:23:17 momjian Exp $ PostgreSQL documentation --> @@ -28,6 +28,7 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } ] TABLE <replaceable class="PAR ] ) [ INHERITS ( <replaceable>parent_table</replaceable> [, ... ] ) ] [ WITH OIDS | WITHOUT OIDS ] +[ WITH (FILLFACTOR = <replaceable>fillfactor</replaceable>) ] [ ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP } ] [ TABLESPACE <replaceable class="PARAMETER">tablespace</replaceable> ] @@ -304,6 +305,15 @@ and <replaceable class="PARAMETER">table_constraint</replaceable> is: </varlistentry> <varlistentry> + <term><literal>WITH (FILLFACTOR = <replaceable>fillfactor</replaceable>)</literal></term> + <listitem> + <para> + This optional clause specifies the table's fillfactor in percentage. + </para> + </listitem> + </varlistentry> + + <varlistentry> <term><literal>CONSTRAINT <replaceable class="PARAMETER">constraint_name</replaceable></literal></term> <listitem> <para> |