| From: | Mario Splivalo <mario(dot)splivalo(at)mobart(dot)hr> |
|---|---|
| To: | Emil Rachovsky <zsevgymko(at)yahoo(dot)com> |
| Cc: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: How to find a temporary table |
| Date: | 2006-01-27 13:33:09 |
| Message-ID: | 1138368789.28020.0.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On Fri, 2006-01-27 at 04:48 -0800, Emil Rachovsky wrote:
> Hi,
> I am using PostgreSQL 8.1.0 . How can I find a temp
> table from my session, having the name of the table?
> Can anyone show me what query should I execute? I've
> tried some things but I receive mixed results of
> tables from different sessions, which is strange.
What do you mean by 'temp table from your session'?
How did you create the temp table in the first place?
Mario
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pandurangan R S | 2006-01-27 13:33:15 | Re: Change SERIAL to INTEGER |
| Previous Message | frank church | 2006-01-27 13:21:36 | REPOST:Memory Allocation error using pg_dump on 7.4 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-01-27 14:55:39 | Re: filtering after join |
| Previous Message | Pandurangan R S | 2006-01-27 12:58:08 | Re: How to find a temporary table |