Bruce Momjian wrote:
> [ Charset ISO-8859-1 unsupported, converting... ]
> >
> > I was trying to check my temp table structure, but failed (7.1 beta4)
> > and I found the following item in the TODO list (without '-').
> >
> > * allow psql \d to show temporary table structure
> >
> > Is there any workaround or equivalent SQL available at this moment?
>
> You can do a \dS in psql and find the correct pg_temp* table.
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
--
LM.Liu