From: Mario Splivalo <mario.splivalo@mobart.hr>
To: Emil Rachovsky <zsevgymko@yahoo.com>
Cc: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: Re: How to find a temporary table
Date: Fri, 27 Jan 2006 14:33:09 +0100
Message-ID: <1138368789.28020.0.camel@localhost.localdomain> (raw)
In-Reply-To: <20060127124850.15170.qmail@web54311.mail.yahoo.com>
References: <20060127124850.15170.qmail@web54311.mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mario.splivalo@mobart.hr, zsevgymko@yahoo.com
Subject: Re: How to find a temporary table
In-Reply-To: <1138368789.28020.0.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox