Re: MySQL-style "create temporary table foo select ..."

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