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 ..."
Date: Wed, 21 Jul 2004 16:28:19 +0100
Message-ID: <20040721152818.GB23820@gbdirect.co.uk> (raw)
In-Reply-To: <40FE86C2.8080903@webde-ag.de>
References: <20040721144949.GA23820@gbdirect.co.uk>
<40FE86C2.8080903@webde-ag.de>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: geoffr@gbdirect.co.uk, mkl@webde-ag.de
Subject: Re: MySQL-style "create temporary table foo select ..."
In-Reply-To: <20040721152818.GB23820@gbdirect.co.uk>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox