Re: display temp table structure?

> 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
  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, Pennsylvania 19026