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