Postgres Pro
Downloads
Home   >   mailing lists

CREATE TABLE IF NOT EXISTS AS - Mailing list pgsql-hackers

From David E. Wheeler
Subject CREATE TABLE IF NOT EXISTS AS
Date
Msg-id 93F0DFD6-DF72-4345-9AD4-28087495D420@justatheory.com
Whole thread Raw
Responses Re: CREATE TABLE IF NOT EXISTS AS
List pgsql-hackers
Tree view 
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
REPLACEwould be useful? 

Best,

David

pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Review:Patch: SSL: prefer server cipher order
Next
From: Fujii Masao
Date:
Subject: Re: New option for pg_basebackup, to specify a different directory for pg_xlog