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.kla...@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.kla...@gmail.com >
