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

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> TODO has:
> * Allow psql \d to show temporary table structure
> Looks like it works fine now with schemas:

More accurately, it's no more broken for temp tables than any other
tables at the moment.

regression=# create table foo (f1 int);
CREATE TABLE
regression=# create temp table foo (f1 text, f2 float);
CREATE TABLE
regression=# \d foo
Table "foo"
Column | Type | Modifiers
--------+------------------+-----------
f1 | integer |
f1 | text |
f2 | double precision |

regression=#

Even uglier cases occur if some other connection has also created
a temp table named foo. You should *not* see that in \d ... but
you will.

> I will mark the TODO as done.

It's not really done, but the remaining fixes will fall out of making
psql schema-aware.

regards, tom lane