File tree 1 file changed +7
-10
lines changed
1 file changed +7
-10
lines changed Original file line number Diff line number Diff line change @@ -336,16 +336,13 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
336
336
</para>
337
337
<para>
338
338
Not-null constraints are always copied to the new table.
339
- <literal>CHECK</literal> constraints will only be copied if
340
- <literal>INCLUDING CONSTRAINTS</literal> is specified; other types of
341
- constraints will never be copied. Also, no distinction is made between
342
- column constraints and table constraints — when constraints are
343
- requested, all check constraints are copied.
344
- </para>
345
- <para>
346
- Any indexes on the original table will not be created on the new
347
- table, unless the <literal>INCLUDING INDEXES</literal> clause is
348
- specified.
339
+ <literal>CHECK</literal> constraints will be copied only if
340
+ <literal>INCLUDING CONSTRAINTS</literal> is specified.
341
+ Indexes, <literal>PRIMARY KEY</>, and <literal>UNIQUE</> constraints
342
+ on the original table will be created on the new table only if the
343
+ <literal>INCLUDING INDEXES</literal> clause is specified.
344
+ No distinction is made between column constraints and table
345
+ constraints.
349
346
</para>
350
347
<para><literal>STORAGE</> settings for the copied column definitions will only
351
348
be copied if <literal>INCLUDING STORAGE</literal> is specified. The
You can’t perform that action at this time.
0 commit comments