create temporary table tmp_foo AS select * from foo;
Geoff Richards schrieb:
> 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?
In response to
pgsql-sql by date
|Next:||From: Javier Tesis Tolosa Trabajo||Date: 2004-07-21 15:08:46|
|Subject: Sorry too many conecctions|
|Previous:||From: Stephan Szabo||Date: 2004-07-21 14:51:20|
|Subject: Re: immutable function calling stable function|