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

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(dot)klaver(at)gmail(dot)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(dot)klaver(at)gmail(dot)com
>