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