Re: Possible Bug regarding temp tables (sql or psql?) - Mailing list pgsql-sql

Bruce Momjian <pgman@candle.pha.pa.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