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

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 TABLE
test=> \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(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