Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commite2989fc

Browse files
committed
docs: mention CREATE TABLE LIKE linkage using INCLUDING DEFAULTS
Mention that CREATE TABLE LIKE INCLUDING DEFAULTS creates a link betweenthe original and new tables if a default function modifies the database,like nextval().
1 parent71c6a8e commite2989fc

File tree

1 file changed

+4
-1
lines changed

1 file changed

+4
-1
lines changed

‎doc/src/sgml/ref/create_table.sgml

Lines changed: 4 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -329,7 +329,10 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI
329329
</para>
330330
<para>
331331
Default expressions for the copied column definitions will only be
332-
copied if <literal>INCLUDING DEFAULTS</literal> is specified. The
332+
copied if <literal>INCLUDING DEFAULTS</literal> is specified.
333+
Defaults that call database-modification functions, like
334+
<function>nextval</>, create a linkage between the original and
335+
new tables. The
333336
default behavior is to exclude default expressions, resulting in the
334337
copied columns in the new table having null defaults.
335338
</para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp