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

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

            regards, tom lane