Message-ID: <40FE86C2.8080903@webde-ag.de>
Date: Wed, 21 Jul 2004 17:07:46 +0200
From: Michael Kleiser <mkl@webde-ag.de>
Reply-To: mkl@webde-ag.de
Organization: WEB.DE AG
User-Agent: Mozilla/5.0 (X11; U; Linux i686; de-AT; rv:1.3.1) Gecko/20030425
MIME-Version: 1.0
To: Geoff Richards <geoffr@gbdirect.co.uk>
Cc: pgsql-sql@postgresql.org
Subject: Re: MySQL-style "create temporary table foo select ..."
References: <20040721144949.GA23820@gbdirect.co.uk>
In-Reply-To: <20040721144949.GA23820@gbdirect.co.uk>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

create temporary table tmp_foo AS select * from foo;

Geoff Richards schrieb:
> Hi,
> 
> I've got some code that currently uses MySQL, and it copies an existing
> table into a temporary one like so:
> 
>    create temporary table tmp_foo select * from foo;
> 
> That creates 'tmp_foo' with the same columns as 'foo', which is
> very convenient.  I can't seem to find any reference to how to do
> that with Postgres (and I'd like if possible to ditch MySQL).
> 
> Just wondering if anyone has ideas about how to do this?  I'd like
> to avoid having to work up a table definition to define the temp
> table's columns.
> 
> Or maybe I could do some sort of trick with the system catalog tables
> to get the column information in a convenient form?
> 
>    cheers,
>       geoff
>