Where can I find created temporary table in posgresql folders?!? If I do select * from temp_table; than I got result, but cannot see it structure of my database in the PgAdmin?!
+1
A:
Temporary tables get put into a schema called "pg_temp_NNN", where "NNN" indicates which server backend you're connected to. This is implicitly added to your search path in the session that creates them.
Note that you can't access one connection's temp tables via another connection... so depending on how exactly pgAdmin organises its connections, even being able to find the tables in the object explorer might not be useful.
araqnid
2010-06-14 12:54:47
pgAdmin uses separate connections for the object browser and the query tool, so it will not be possible to see the temp tables this way.
Magnus Hagander
2010-06-14 17:41:42