Re: temporary tables - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: temporary tables
Date
Msg-id 200206112333.g5BNXmW28590@candle.pha.pa.us
Whole thread Raw
In response to temporary tables  ("Marie G. Tuite" <marie.tuite@edisonaffiliates.com>)
List pgsql-sql
Marie G. Tuite wrote:
> Hey there,
> 
> Does anybody know where temporary table info is stored for the duration of
> the temp table session?

The mapping is kept in a per-backend memory area.  You can't really
access the mapping, but in 7.3, it will be in a temp schema which will
be visible, I think.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-sql by date:

Previous
From: "Marie G. Tuite"
Date:
Subject: temporary tables
Next
From: "Beth Gatewood"
Date:
Subject: make a unique index for foreign keys?