From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: frank_limpert@yahoo.com
Subject: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data
Date: Wed, 09 Feb 2022 13:02:51 +0000
Message-ID: <164441177106.9677.5991676148704507229@wrigleys.postgresql.org> (raw)
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/14/sql-createtableas.html
Description:
If I create a table with CREATE TABLE IF NOT EXISTS table_name AS, and the
table exists already, I get a NOTICE instead of an ERROR.
I wanted to have it clarified explicitly that the data from the SELECT
statement is ignored in this case.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, frank_limpert@yahoo.com
Subject: Re: CREATE TABLE AS, section IF NOT EXISTS should clarify what happens to the data
In-Reply-To: <164441177106.9677.5991676148704507229@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox