doc_auto_constraint_names.patch

text/x-patch

Filename: doc_auto_constraint_names.patch

Type: text/x-patch

Part: 0

Message: Doc patch: Document names of automatically created constraints and indexes

Patch

Same data as JSON: GET /api/v1/attachments/:id/patch the parsed metadata as JSON — format, series position, per-file stats; never the diff bytes. API reference →

Format: unified

File	+	−
doc/src/sgml/ref/create_table.sgml	15	0

diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml
index 445ca40..da87574 100644
--- a/doc/src/sgml/ref/create_table.sgml
+++ b/doc/src/sgml/ref/create_table.sgml
@@ -486,6 +486,14 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
       primary key constraint defined for the table.  (Otherwise it
       would just be the same constraint listed twice.)
      </para>
+
+     <para>
+      The name of the index created when <literal>UNIQUE</literal> is
+      used is <literal><replaceable
+      class="PARAMETER">tablename</replaceable>_<replaceable
+      class="PARAMETER">colname</replaceable>_key</literal>.
+     </para>
+
     </listitem>
    </varlistentry>
 
@@ -514,6 +522,13 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
       different from other sets of columns named by any unique
       constraint defined for the same table.
      </para>
+
+     <para>
+       The name of the primary key constraint, and the name of the
+       index which enforces uniqueness, is <literal><replaceable
+       class="PARAMETER">tablename</replaceable>_pkey</literal>.
+     </para>
+
     </listitem>
    </varlistentry>