create table if not exists xx AS select ... - Mailing list pgsql-general

From Daniel Caldeweyher
Subject create table if not exists xx AS select ...
Date
Msg-id CAN3G7dYkzRtWT_u2NO4B4LC6WUBtRQ-nPxtrR0PcLLWr+uqJcw@mail.gmail.com
Whole thread Raw
Responses Re: create table if not exists xx AS select ...  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Hi All,

I am not entirely sure if this is a bug (fails on 9.3 and 9.4) or working as intended:

create table if not exists test (
foo boolean
);

create table if not exists test2 as 
select * from test where 1=0;
/*
ERROR:  syntax error at or near "as"
LINE 1: create table if not exists test2 as 
*/

create table test2 as 
select * from test where 1=0;

Thanks

Daniel

pgsql-general by date:

Previous
From: Haribabu Kommi
Date:
Subject: Re: Unicode license compatibility with PostgreSQL license
Next
From: Michael Paquier
Date:
Subject: Re: create table if not exists xx AS select ...