Re: Is there a way to elegantly do a : CREATE TEMP TABLE X AS SELECT .... ON COMMIT DROP - Mailing list pgsql-general

Tom Lane wrote:
> Colin Wetherbee <cww@denterprises.org> 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