Appears psql needs to know how to differentiate between it's own temp
tables and those of another connection. On the plus side, this takes
care of a TODO item to add temp table listings to psql.
Connection 1:
template1=# create temp table junk(col1 int4);
CREATE
template1=# select * from junk;
col1
------
(0 rows)
Connection 2:
template1=# \d
List of relations
Name | Type | Owner
------+-------+-------
junk | table | rbt
(1 row)
template1=# select * from junk;
ERROR: Relation "junk" does not exist
template1=# create temp table junk (col4 text);
CREATE
List of relations
Name | Type | Owner
------+-------+-------
junk | table | rbt
junk | table | rbt