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

[Tom Lane]

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 ...

                        regards, tom lane

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