Dave Page wrote:
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: 03 April 2006 01:21
...snip
2) pgAdmin uses a separate connection for query tool windows. Because
temp tables exist only for the life of the session, if
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> [EMAIL PROTECTED]
> Sent: 03 April 2006 01:21
> To: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Cant find temp tables
>
> could be. i will have a look at th
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.
---(end of broadcast)---
TIP 6: explain analyze is your frien
[EMAIL PROTECTED] wrote:
hi all,
i am struggling with temp tables. i have a statement like CREATE TEMP
TABLE test (a BIGINT);
it executes successfully, hence i know that the table has been created.
but i cant see the table within the DB using PGADMIN. if i do SELECT *
FROM test; it returns 0 reco
