Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f8F93K727050 for ; Sat, 15 Sep 2001 05:03:21 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f8F8grn06131 for pgsql-sql@postgresql.org; Sat, 15 Sep 2001 04:42:53 -0400 (EDT) (envelope-from news) From: Hans-Juergen Schoenig X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Checking for table existence Date: Sat, 15 Sep 2001 10:48:02 +0200 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 6 Message-ID: <3BA315C2.DBC51E25@bachata.cybertec.at> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Complaints-To: scrappy@hub.org X-Mailer: Mozilla 4.77 [de] (X11; U; Linux 2.4.9-xfs i686) X-Accept-Language: en To: pgsql-sql@postgresql.org X-Archive-Number: 200109/111 X-Sequence-Number: 4776 Simply look it up in the system tables: SELECT * FROM pg_class WHERE relname='mydata'; Hans