temporary tables

From: Dan <dan_at_onshare.com>
Date: Fri, 01 Oct 1999 17:06:45 -0400
Message-ID: <37F52265.D88D33A3@onshare.com>

In order to avoid hard-drive writes, I can use temporary tables as follows:

CREATE GLOBAL TEMPORARY TABLE foo(var1 integer) ON COMMIT PRESERVE ROWS;

I realize that this table is only alive for the current session; I don't mind that.

The question is, is there any way to access rows of this table through another session / another connection to the database with the same user? Although the table information is visible in each session where the user is connected, individual rows are not visible across sessions.

Thanks,

Dan Received on Fri Oct 01 1999 - 16:06:45 CDT