Horton

Re: Add missing CREATE TABLE IF NOT EXISTS table_name AS EXECUTE query;

Michael Paquier <michael@paquier.xyz>

View thread View on postgr.es
From: Michael Paquier <michael@paquier.xyz>
To: Ramanarayana <raam.soft@gmail.com>
Cc: Andreas Karlsson <andreas@proxel.se>, PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Date: 2019-03-10T22:42:20Z
Lists: pgsql-hackers 
On Sun, Mar 10, 2019 at 06:56:57PM +0530, Ramanarayana wrote:
> Will it be helpful if the comments section of ExecuteStmt in gram.y is
> updated to include the IF NOT EXISTS clause.Something like this
> 
> CREATE TABLE <name> [IF NOT EXISTS] AS EXECUTE <plan_name> [(params, ...)]

Not sure it helps much.  The other clauses don't include that much
details, and the grammar supported can be guessed easily from the
code.
--
Michael

Commits

  1. Fix support for CREATE TABLE IF NOT EXISTS AS EXECUTE