Home > mailing lists

CREATE TABLE AS does not support IF NOT EXISTS? - Mailing list pgsql-general

From	David Waddy
Subject	CREATE TABLE AS does not support IF NOT EXISTS?
Date	February 12, 2012 18:43:18
Msg-id	CAD3FPx_6RieNMmekdohrXAX3rJwfOt34F0M-WFoB-JXrTKD7Fg@mail.gmail.com Whole thread Raw
Responses	Re: CREATE TABLE AS does not support IF NOT EXISTS?
List	pgsql-general

This works:

CREATE TEMP TABLE temp_medical_summary AS (SELECT * from bov.medical_summary)

This gives an error:

CREATE TEMP TABLE IF NOT EXISTS temp_medical_summary AS (SELECT * from bov.medical_summary)

It would seem that CREATE TABLE AS does not support IF NOT EXISTS. Is this true?

David Waddy

From: Thom Brown
Date: 12 February 2012, 18:00:45
Subject: Re: Regex match not back-referencing in function

From: Adrian Klaver
Date: 12 February 2012, 18:50:47
Subject: Re: CREATE TABLE AS does not support IF NOT EXISTS?