How to find a temporary table

From: Emil Rachovsky <zsevgymko(at)yahoo(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: How to find a temporary table
Date: 2006-01-27 12:48:50
Message-ID: 20060127124850.15170.qmail@web54311.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


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.

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pandurangan R S 2006-01-27 12:58:08 Re: How to find a temporary table
Previous Message Richard Huxton 2006-01-27 10:50:35 Re: question about large databases

Browse pgsql-sql by date

  From Date Subject
Next Message Pandurangan R S 2006-01-27 12:58:08 Re: How to find a temporary table
Previous Message frank church 2006-01-27 11:03:32 REPOST:Memory Allocation error using pg_dump on 7.4