Thread: CREATE TABLE AS does not support IF NOT EXISTS?

CREATE TABLE AS does not support IF NOT EXISTS?

From
David Waddy
Date:

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

Re: CREATE TABLE AS does not support IF NOT EXISTS?

From
Adrian Klaver
Date:
On Sunday, February 12, 2012 11:42:37 am David Waddy wrote:
> 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?

FYI the Postgres version would be helpful, as syntax support changes over
versions:)

In any case the most recent production version docs show IF NOT EXISTS is not
supported:
http://www.postgresql.org/docs/9.1/interactive/sql-createtableas.html

>
> David Waddy

--
Adrian Klaver
adrian.klaver@gmail.com

Re: CREATE TABLE AS does not support IF NOT EXISTS?

From
David Waddy
Date:
Thank-you, mystery solved! I was reading the "CREATE TABLE" docs and not the "CREATE TABLE AS" docs. My mistake.

David Waddy


On Sun, Feb 12, 2012 at 3:50 PM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
On Sunday, February 12, 2012 11:42:37 am David Waddy wrote:
> 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?

FYI the Postgres version would be helpful, as syntax support changes over
versions:)

In any case the most recent production version docs show IF NOT EXISTS is not
supported:
http://www.postgresql.org/docs/9.1/interactive/sql-createtableas.html

>
> David Waddy

--
Adrian Klaver
adrian.klaver@gmail.com