Search Postgresql Archives

Re: create table if not exists xx AS select ...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.paquier@xxxxxxxxx> wrote:
On Mon, Mar 23, 2015 at 10:28 AM, Daniel Caldeweyher
<daniel.caldeweyher@xxxxxxxxxxxxxxxxxx> 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

Attachment: image011.png
Description: PNG image

Attachment: image012.png
Description: PNG image

Attachment: image007.png
Description: PNG image

Attachment: image008.png
Description: PNG image

Attachment: image009.png
Description: PNG image

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux