diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/ref/create_table.sgml | 17 |
1 files changed, 12 insertions, 5 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 9d552241a16..c1855b8d827 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -924,8 +924,8 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM <para> This clause creates the column as an <firstterm>identity column</firstterm>. It will have an implicit sequence attached to it - and the column in new rows will automatically have values from the - sequence assigned to it. + and in newly-inserted rows the column will automatically have values + from the sequence assigned to it. Such a column is implicitly <literal>NOT NULL</literal>. </para> @@ -955,9 +955,16 @@ WITH ( MODULUS <replaceable class="parameter">numeric_literal</replaceable>, REM </para> <para> - The optional <replaceable>sequence_options</replaceable> clause can be - used to override the options of the sequence. - See <xref linkend="sql-createsequence"/> for details. + The optional <replaceable>sequence_options</replaceable> clause can + be used to override the parameters of the sequence. The available + options include those shown for <xref linkend="sql-createsequence"/>, + plus <literal>SEQUENCE NAME <replaceable>name</replaceable></literal>, + <literal>LOGGED</literal>, and <literal>UNLOGGED</literal>, which + allow selection of the name and persistence level of the + sequence. Without <literal>SEQUENCE NAME</literal>, the system + chooses an unused name for the sequence. + Without <literal>LOGGED</literal> or <literal>UNLOGGED</literal>, + the sequence will have the same persistence level as the table. </para> </listitem> </varlistentry> |