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/

Reply via email to