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