Commit7d66cce

committed

doc: clarify CREATE TABLE AS ... IF NOT EXISTS

Mention that the table is not modified if it already exists.Reported-by: frank_limpert@yahoo.comDiscussion:https://postgr.es/m/164441177106.9677.5991676148704507229@wrigleys.postgresql.orgBackpatch-through: 10

1 parent4d807bb commit7d66cceCopy full SHA for 7d66cce

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 3 deletions

Original file line number	Diff line number	Diff line change
`@@ -100,9 +100,8 @@ CREATE [ [ GLOBAL \| LOCAL ] { TEMPORARY \| TEMP } \| UNLOGGED ] TABLE [ IF NOT EXI`
`100`	`100`	`<term><literal>IF NOT EXISTS</literal></term>`
`101`	`101`	`<listitem>`
`102`	`102`	`<para>`
`103`		`- Do not throw an error if a relation with the same name already exists.`
`104`		`- A notice is issued in this case. Refer to <xref linkend="sql-createtable"/>`
`105`		`- for details.`
	`103`	`+ Do not throw an error if a relation with the same name already`
	`104`	`+ exists; simply issue a notice and leave the table unmodified.`
`106`	`105`	`</para>`
`107`	`106`	`</listitem>`
`108`	`107`	`</varlistentry>`

Comments

(0)