Received: from bleys.tpgi.com.au (bleys.tpgi.com.au [203.12.160.38]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2O4mCw52672 for ; Fri, 23 Mar 2001 23:48:12 -0500 (EST) (envelope-from quals@bigfoot.com) Received: (from smtpd@localhost) by bleys.tpgi.com.au (8.11.2/8.11.2) id f2O4kdR30762; Sat, 24 Mar 2001 15:46:39 +1100 Received: from bri3-56k-249.tpgi.com.au(202.7.184.249), claiming to be "hnjack" via SMTP by bleys.tpgi.com.au, id smtpdkhTpzs; Sat Mar 24 15:46:30 2001 Message-ID: <005f01c0b41c$eb801e60$2400a8c0@hnjack> From: "datactrl" To: , Subject: how do I check if a temporary table exists? Date: Sat, 24 Mar 2001 14:43:04 +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 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200103/471 X-Sequence-Number: 2140 How do I check if a temporary table exists? Searching pg_tables with a temporary table name we chose always fails. JACK