X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B5D859DCAD5 for ; Fri, 27 Jan 2006 09:34:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 75464-09 for ; Fri, 27 Jan 2006 09:34:37 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 2B9CD9DCA67 for ; Fri, 27 Jan 2006 09:34:32 -0400 (AST) Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97]) by svr4.postgresql.org (Postfix) with ESMTP id BDCE75AF887 for ; Fri, 27 Jan 2006 13:34:35 +0000 (GMT) Received: from ls401.t-com.hr (ls401.t-com.hr [195.29.150.236]) by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id k0RDYUSn029370; Fri, 27 Jan 2006 14:34:31 +0100 Received: from ls401.t-com.hr (localhost.localdomain [127.0.0.1]) by ls401.t-com.hr (Qmlai) with ESMTP id AA67B7002D; Fri, 27 Jan 2006 14:34:30 +0100 (CET) X-Envelope-Sender: mario.splivalo@mobart.hr X-Envelope-Sender: mario.splivalo@mobart.hr Received: from 83-131-54-219.adsl.net.t-com.hr (83-131-54-219.adsl.net.t-com.hr [83.131.54.219]) by ls401.t-com.hr (Qmlai) with ESMTP id BA369A8062; Fri, 27 Jan 2006 14:34:29 +0100 (CET) Subject: Re: How to find a temporary table From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Emil Rachovsky Cc: "pgsql-sql@postgresql.org" In-Reply-To: <20060127124850.15170.qmail@web54311.mail.yahoo.com> References: <20060127124850.15170.qmail@web54311.mail.yahoo.com> Content-Type: text/plain Organization: Mob-Art Date: Fri, 27 Jan 2006 14:33:09 +0100 Message-Id: <1138368789.28020.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.103 required=5 tests=[AWL=0.103] X-Spam-Score: 0.103 X-Spam-Level: X-Archive-Number: 200601/196 X-Sequence-Number: 23985 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