diff options
| author | Bruce Momjian <bruce@momjian.us> | 2022-08-12 10:59:00 -0400 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2022-08-12 10:59:00 -0400 |
| commit | 7d66ccee99d57055a2ef42aa14b60ff6bdae5f1c (patch) | |
| tree | 83db80d3d1ddf5691bbbb3809eb9b004bb166346 | |
| parent | 4d807bbc4b336f7d9e091903ca3a6f9d77b2a934 (diff) | |
| download | postgresql-7d66ccee99d57055a2ef42aa14b60ff6bdae5f1c.tar.gz postgresql-7d66ccee99d57055a2ef42aa14b60ff6bdae5f1c.zip | |
doc: clarify CREATE TABLE AS ... IF NOT EXISTS
Mention that the table is not modified if it already exists.
Reported-by: frank_limpert@yahoo.com
Discussion: https://postgr.es/m/164441177106.9677.5991676148704507229@wrigleys.postgresql.org
Backpatch-through: 10
| -rw-r--r-- | doc/src/sgml/ref/create_table_as.sgml | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/doc/src/sgml/ref/create_table_as.sgml b/doc/src/sgml/ref/create_table_as.sgml index 07558ab56c9..8429333e3af 100644 --- a/doc/src/sgml/ref/create_table_as.sgml +++ b/doc/src/sgml/ref/create_table_as.sgml @@ -100,9 +100,8 @@ CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | TEMP } | UNLOGGED ] TABLE [ IF NOT EXI <term><literal>IF NOT EXISTS</literal></term> <listitem> <para> - Do not throw an error if a relation with the same name already exists. - A notice is issued in this case. Refer to <xref linkend="sql-createtable"/> - for details. + Do not throw an error if a relation with the same name already + exists; simply issue a notice and leave the table unmodified. </para> </listitem> </varlistentry> |