> Thanx Bruce
> 
> What I found is something like pg_temp.25865.0.   Do we have some kind of
> mapping table between the "real temp table name" and pg_temp*.   If there
> are more than one temp tables, I need a way to differentiate them.
> 
> Thanks for your help

There is no user-visible mapping, though the number is the process id. 
You could use that.  I think you can get the backend process id somehow,
but I am not sure how.  Anyone?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl

Reply via email to