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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026