Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57]) by postgresql.org (Postfix) with ESMTP id 1F30D475943 for ; Mon, 25 Mar 2002 05:17:46 -0500 (EST) Received: from jac (bri5-56k-062.tpgi.com.au [203.213.6.62]) by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id g2PAHkj17517 for ; Mon, 25 Mar 2002 21:17:46 +1100 Message-ID: <00e501c1d3e6$4ea1a600$1400a8c0@jac> From: "jack" To: References: <200203250354.g2P3sEC02066@candle.pha.pa.us> <006b01c1d3b3$1c72b210$1400a8c0@jac> <000a01c1d3b3$f854d380$0108a8c0@automaton> Subject: Re: About temporary table Date: Mon, 25 Mar 2002 20:17:44 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200203/309 X-Sequence-Number: 7188 ----- Original Message ----- From: "David Stanaway" To: "jack" Sent: Monday, March 25, 2002 2:17 PM Subject: Re: [SQL] About temporary table > > ----- Original Message ----- > From: jack > To: > Sent: Sunday, March 24, 2002 10:11 PM > Subject: Re: [SQL] About temporary table > You can see if its in the relevant system tables, then drop it. But how can we find the exact name of a temporary table? Or do you know which system table has the name mapping? JACK