Thread: can't see temporary tables in PGAdmin III browser

Hi,<br /><br />I can create temporary tables with psql. In PGAdmin III, however, despite reporting a success after the
SQLcommand, I cannot find the newly-created temp table anywhere in the object browser. What's up?<br /><br />
Thanks,<br/><br />Lille<br /> 

On Fri, Feb 18, 2011 at 6:20 PM, Lille Penguini
<lille.penguini@gmail.com> wrote:
> Hi,
>
> I can create temporary tables with psql. In PGAdmin III, however, despite
> reporting a success after the SQL command, I cannot find the newly-created
> temp table anywhere in the object browser. What's up?

Nothing. Temp tables are per-session objects, so they'll only show up
in the session in which you create them.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company