From: Geoff Richards <geoffr@gbdirect.co.uk>
To: pgsql-sql@postgresql.org
Subject: MySQL-style "create temporary table foo select ..."
Date: Wed, 21 Jul 2004 15:49:50 +0100
Message-ID: <20040721144949.GA23820@gbdirect.co.uk> (raw)
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
Subject: Re: MySQL-style "create temporary table foo select ..."
In-Reply-To: <20040721144949.GA23820@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