Re: display temp table structure? - Mailing list pgsql-general

From Bruce Momjian
Subject Re: display temp table structure?
Date
Msg-id 200103122215.RAA23336@candle.pha.pa.us
Whole thread Raw
In response to display temp table structure?  (Limin Liu <limin@pumpkinnet.com>)
List pgsql-general
[ 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

pgsql-general by date:

Previous
From: newsreader@mediaone.net
Date:
Subject: -F option again
Next
From: Limin Liu
Date:
Subject: Re: display temp table structure?