Received: from kitana.asti.dost.gov.ph (kitana.asti.dost.gov.ph [202.90.128.8]) by postgresql.org (Postfix) with ESMTP id 50863475498 for ; Thu, 1 Aug 2002 06:01:03 -0400 (EDT) Received: from Askr (askr.asti.dost.gov.ph [10.10.5.36]) by kitana.asti.dost.gov.ph (Postfix) with ESMTP id 9370025847 for ; Thu, 1 Aug 2002 17:58:12 +0800 (PHT) Subject: determine if a table exists From: Joseph Syjuco To: postgres Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0.2-5mdk Date: 01 Aug 2002 18:08:42 -0400 Message-Id: <1028239723.2474.8.camel@Askr> Mime-Version: 1.0 X-Archive-Number: 200208/7 X-Sequence-Number: 8853 how do i determine if a table exists using select statement i want to find out if it exists if not ill create it if yes then ill do some editing with it TIA