Colin Wetherbee <cww(at)denterprises(dot)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