Re: Possible Bug regarding temp tables (sql or psql?)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Possible Bug regarding temp tables (sql or psql?)
Дата
Msg-id 200207050209.g6529RT19334@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Possible Bug regarding temp tables (sql or psql?)  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Ответы Re: Possible Bug regarding temp tables (sql or psql?)
Re: Possible Bug regarding temp tables (sql or psql?)
Список pgsql-sql
Christopher Kings-Lynne wrote:
> IIRC they are only visible in the connection that created them?  Am I right?
> Either way, I don't think \d will show them - there might be another
> command...
> 

TODO has:
* Allow psql \d to show temporary table structure

Looks like it works fine now with schemas:test=> create temp table xx(x int);CREATE TABLEtest=> \d    List of relations
Name| Type  |  Owner   ------+-------+---------- x    | table | postgres xx   | table | postgres(2 rows)
 

I will mark the TODO as done.

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




В списке pgsql-sql по дате отправления:

Предыдущее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: Possible Bug regarding temp tables (sql or psql?)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Possible Bug regarding temp tables (sql or psql?)