Re: display temp table structure?

[ 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.

--
  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