Re: store multiple rows with the SELECT INTO statement

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Janek Sendrowski <janek12(at)web(dot)de>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: store multiple rows with the SELECT INTO statement
Date: 2013-09-03 16:23:40
Message-ID: 1378225420.33623.YahooMailNeo@web162904.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> wrote:

> PostgreSQL doesn't support a table variables

Well, from a relational theory point of view, a variable which
stores a relation is what a table *is*.  PostgreSQL attempts to
store data for temporary tables in RAM and spill them to disk only
as needed.  So IMO the response suggesting a temporary table was on
target.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-09-03 16:24:38 Re: How to find out unused indexes?
Previous Message Kevin Grittner 2013-09-03 16:12:27 Re: ALTER TABLE transaction isolation problem