Thanks Michael, I suppose I should have checked the docs for CREATE TABLE AS and not just CREATE TABLE :)
Regards, Daniel On Mon, Mar 23, 2015 at 11:41 AM, Michael Paquier <michael.paqu...@gmail.com > wrote: > On Mon, Mar 23, 2015 at 10:28 AM, Daniel Caldeweyher > <daniel.caldewey...@pricefinder.com.au> wrote: > > I am not entirely sure if this is a bug (fails on 9.3 and 9.4) or > working as > > intended: > > [...] > > create table test2 as > > select * from test where 1=0; > > This works as intended, CREATE TABLE AS does not support IF NOT EXISTS > in 9.4 and 9.3: > http://www.postgresql.org/docs/9.3/static/sql-createtableas.html > http://www.postgresql.org/docs/9.4/static/sql-createtableas.html > But it does in 9.5 and onwards: > http://www.postgresql.org/docs/devel/static/sql-createtableas.html > Regards, > -- > Michael >
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
