> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] On Behalf Of
> sconeek@gmail.com
> Sent: 03 April 2006 01:21
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Cant find temp tables
>
> could be. i will have a look at the pgadmin site and see if i
> can find anything. but the pgadmin guys couldnt have missed
> this problem, seems to be pretty important functionality. thanks.
Hi, pgAdmin guy here!
There are a couple of issues to consider when trying to use temp tables
in pgAdmin:
1) They live in pg_temp_NN schemas, which by default are hidden. Turn on
Display -> System Objects to see them.
2) pgAdmin uses a separate connection for query tool windows. Because
temp tables exist only for the life of the session, if you close the
query tool (or whatever other session you created the table in), all the
pg_class/pg_attribute rows will be removed so pgAdmin won't see them no
matter how much you refresh the tree.
Regards, Dave.