Re: How to find a temporary table - Mailing list pgsql-sql

From Mario Splivalo
Subject Re: How to find a temporary table
Date
Msg-id 1138368789.28020.0.camel@localhost.localdomain
Whole thread Raw
In response to How to find a temporary table  (Emil Rachovsky <zsevgymko@yahoo.com>)
List 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



pgsql-sql by date:

Previous
From: Emil Rachovsky
Date:
Subject: How to find a temporary table
Next
From: Tom Lane
Date:
Subject: Re: filtering after join