aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2012-08-26 16:33:11 -0400
committerBruce Momjian <bruce@momjian.us>2012-08-26 16:33:11 -0400
commitde87d4704432e98a327dbf42dbc4711fa2628a9c (patch)
tree78fb504841efac1ddc244724b743b5e455d373a4
parent9e9a5b71d56a40292e6485ff03e1b65351664ece (diff)
downloadpostgresql-de87d4704432e98a327dbf42dbc4711fa2628a9c.tar.gz
postgresql-de87d4704432e98a327dbf42dbc4711fa2628a9c.zip
Clarify documentation that primary key and unique constraints are copied
for CREATE TABLE LIKE ... INCLUDING INDEXES. Per report from david.sahagian@emc.com
-rw-r--r--doc/src/sgml/ref/create_table.sgml17
1 files changed, 7 insertions, 10 deletions
diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 19e6f8ed610..445ca406950 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -336,16 +336,13 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
</para>
<para>
Not-null constraints are always copied to the new table.
- <literal>CHECK</literal> constraints will only be copied if
- <literal>INCLUDING CONSTRAINTS</literal> is specified; other types of
- constraints will never be copied. Also, no distinction is made between
- column constraints and table constraints &mdash; when constraints are
- requested, all check constraints are copied.
- </para>
- <para>
- Any indexes on the original table will not be created on the new
- table, unless the <literal>INCLUDING INDEXES</literal> clause is
- specified.
+ <literal>CHECK</literal> constraints will be copied only if
+ <literal>INCLUDING CONSTRAINTS</literal> is specified.
+ Indexes, <literal>PRIMARY KEY</>, and <literal>UNIQUE</> constraints
+ on the original table will be created on the new table only if the
+ <literal>INCLUDING INDEXES</literal> clause is specified.
+ No distinction is made between column constraints and table
+ constraints.
</para>
<para><literal>STORAGE</> settings for the copied column definitions will only
be copied if <literal>INCLUDING STORAGE</literal> is specified. The