create temporary table tmp_foo AS select * from foo;
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
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
