Re: SELECT INTO and ON COMMIT - Mailing list pgsql-general

From Bruce Momjian
Subject Re: SELECT INTO and ON COMMIT
Date
Msg-id 20150513233829.GD31547@momjian.us
Whole thread Raw
In response to SELECT INTO and ON COMMIT  (Yves Dorfsman <yves@zioup.com>)
Responses Re: SELECT INTO and ON COMMIT  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On Wed, May 13, 2015 at 05:29:36PM -0600, Yves Dorfsman wrote:
>
> Is there any way to add an ON COMMIT clause to a SELECT INTO TEMP TABLE?

Well CREATE TABLE has a ON COMMIT { PRESERVE ROWS | DELETE ROWS | DROP }
clause, but I don't see it in SELECT INTO, so it seems you have to
create the temp table using CREATE TABLE, then INSERT ... SELECT.

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + Everyone has their own god. +


pgsql-general by date:

Previous
From: Yves Dorfsman
Date:
Subject: SELECT INTO and ON COMMIT
Next
From: "David G. Johnston"
Date:
Subject: Re: SELECT INTO and ON COMMIT