Re: store multiple rows with the SELECT INTO statement - Mailing list pgsql-general

From Kevin Grittner
Subject Re: store multiple rows with the SELECT INTO statement
Date
Msg-id 1378225420.33623.YahooMailNeo@web162904.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: store multiple rows with the SELECT INTO statement  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-general
Pavel Stehule <pavel.stehule@gmail.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


pgsql-general by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: ALTER TABLE transaction isolation problem
Next
From: Jeff Janes
Date:
Subject: Re: How to find out unused indexes?