Date: Wed, 21 Jul 2004 16:28:19 +0100
From: Geoff Richards <geoffr@gbdirect.co.uk>
To: Michael Kleiser <mkl@webde-ag.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: MySQL-style "create temporary table foo select ..."
Message-ID: <20040721152818.GB23820@gbdirect.co.uk>
References: <20040721144949.GA23820@gbdirect.co.uk>
	<40FE86C2.8080903@webde-ag.de>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <40FE86C2.8080903@webde-ag.de>
User-Agent: Mutt/1.5.4i

On Wed, Jul 21, 2004 at 05:07:46PM +0200, Michael Kleiser wrote:
> create temporary table tmp_foo AS select * from foo;

Ah, that's a relief, thanks.  Just what I need.  Must have missed it in
the create table syntax.

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

-- 
Geoff Richards - GBdirect - http://development.gbdirect.co.uk/
tel: 0870 200 7273   sales: 0800 651 0338