Re: SELECT INTO and ON COMMIT

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Melvin Davidson <melvin6925(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <bruce(at)momjian(dot)us>, Yves Dorfsman <yves(at)zioup(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: SELECT INTO and ON COMMIT
Date: 2015-05-14 02:19:19
Message-ID: 20150514021919.GW2523@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Melvin Davidson wrote:
> So perhaps replace the SQL SELECT INTO with SQL ADD INTO ?

No, the alternative spelling is CREATE TABLE AS; we already have it.
(To simply insert a query result into an existing table, the spelling is
INSERT INTO .. SELECT).

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-general by date

  From Date Subject
Next Message S. Richler. 2015-05-14 14:52:51 Connection question
Previous Message Melvin Davidson 2015-05-14 01:04:03 Re: SELECT INTO and ON COMMIT