> -----Original Message----- > From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of > sconeek@xxxxxxxxx > Sent: 03 April 2006 01:21 > To: pgsql-general@xxxxxxxxxxxxxx > 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.
