Received: from rztsun.rz.tu-harburg.de (rztsun.rz.tu-harburg.de [134.28.200.14]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fATEHXm70212 for ; Thu, 29 Nov 2001 09:17:34 -0500 (EST) (envelope-from stony@tyche.svt.tu-harburg.de) Received: from tyche.svt.tu-harburg.de (tyche.svt.tu-harburg.de [134.28.60.94]) by rztsun.rz.tu-harburg.de (8.9.0/8.8.8) with ESMTP id PAA10490 for ; Thu, 29 Nov 2001 15:17:36 +0100 (MET) Received: by tyche.svt.tu-harburg.de (Postfix, from userid 1000) id 0BB4E23CA6; Thu, 29 Nov 2001 15:17:35 +0100 (CET) Date: Thu, 29 Nov 2001 15:17:34 +0100 From: Alexander Steinert To: pgsql-sql@postgresql.org Subject: Re: Check for table existence Message-ID: <20011129151734.C859@tyche.svt.tu-harburg.de> Mail-Followup-To: Alexander Steinert , pgsql-sql@postgresql.org References: <3C055B7E.BB52F0F1@but.auc.dk> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <3C055B7E.BB52F0F1@but.auc.dk>; from mk267673@but.auc.dk on Wed, Nov 28, 2001 at 10:47:42PM +0100 X-Archive-Number: 200111/409 X-Sequence-Number: 5791 > First, let me say that I am new to postgres. I used MySQL before, but.. > ehm.. Welcome. > 1. How can I check if a given table exists? > 2. How can I check if a given existing table has the right > layout? (Correct column names and types) http://archives2.us.postgresql.org/pgsql-sql/2001-07/msg00319.php and http://archives2.us.postgresql.org/pgsql-sql/2001-07/msg00403.php will show you the way to go. Stony