David Goodenough wrote:
I thought I understood that the table would disappear
at the end of the transaction. Other than deleting it, is there something
else I need to do or have I missunderstood that into temporary does?
Dropped when the connection is closed normally, but see the ON COMMIT.
http://www.postgresql.org/docs/8.1/static/sql-createtable.html
You might have to do CREATE TABLE then INSERT INTO ... SELECT though.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/