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

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Lille Penguini <lille(dot)penguini(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: can't see temporary tables in PGAdmin III browser
Date: 2011-02-18 19:11:32
Message-ID: AANLkTinSVdrrBmnbD6qjNtLs+Gwyx=Z=tjC2P2od1jdr@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Fri, Feb 18, 2011 at 6:20 PM, Lille Penguini
<lille(dot)penguini(at)gmail(dot)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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2011-02-20 22:51:28 Re: help running pgAdmin in debian -lenny
Previous Message Lille Penguini 2011-02-18 18:20:05 can't see temporary tables in PGAdmin III browser