CREATE TABLE IF NOT EXISTS AS

From: "David E(dot) Wheeler" <david(at)justatheory(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Cc: Steve Rehfuss <steve(dot)rehfuss(at)iovation(dot)com>
Subject: CREATE TABLE IF NOT EXISTS AS
Date: 2013-11-16 19:24:19
Message-ID: 93F0DFD6-DF72-4345-9AD4-28087495D420@justatheory.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hackers,

Co-worker asked a question I could not answer: Why is IF NOT EXISTS not supported by CREATE TABLE AS? Oversight, perhaps? Or maybe because one expects the table to have the data from the SELECT statement? If the latter, maybe OR REPLACE would be useful?

Best,

David

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fujii Masao 2013-11-16 19:25:23 Re: New option for pg_basebackup, to specify a different directory for pg_xlog
Previous Message Marko Kreen 2013-11-16 14:24:15 Re: Review:Patch: SSL: prefer server cipher order