Postgres Pro
Downloads
Home   >   mailing lists

Re: can't see temporary tables in PGAdmin III browser - Mailing list pgadmin-support

From Dave Page
Subject Re: can't see temporary tables in PGAdmin III browser
Date
Msg-id AANLkTinSVdrrBmnbD6qjNtLs+Gwyx=Z=tjC2P2od1jdr@mail.gmail.com
Whole thread Raw
In response to can't see temporary tables in PGAdmin III browser  (Lille Penguini <lille.penguini@gmail.com>)
List pgadmin-support
Tree view 
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

pgadmin-support by date:

Previous
From: Lille Penguini
Date:
Subject: can't see temporary tables in PGAdmin III browser
Next
From: Guillaume Lelarge
Date:
Subject: Re: help running pgAdmin in debian -lenny