Re: [GENERAL] Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP

[Colin Wetherbee]

Tom Lane wrote:

Colin Wetherbee <[EMAIL PROTECTED]> writes:

Colin Wetherbee wrote:

cww=# CREATE TEMP TABLE foo ON COMMIT DROP AS (SELECT 1 AS a, 2 AS b);

FWIW, the output of \h CREATE TABLE in both 8.1 and 8.2 suggest that this should be possible.

"\h CREATE TABLE AS" is what describes this variant ...

Ah, yes, of course. :)

Colin


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general