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

[Colin Wetherbee <cww@xxxxxxxxxxxxxxxx>]

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


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