Received: from punta.ultra.hr (ip.zadarnet.hr [195.29.197.33]) by hub.org (8.9.3/8.9.3) with ESMTP id LAA21197 for ; Mon, 13 Dec 1999 11:58:47 -0500 (EST) (envelope-from ivo@punta.ultra.hr) Received: by punta.ultra.hr (Postfix, from userid 1001) id 890B53C90D; Mon, 13 Dec 1999 18:31:43 +0100 (CET) Date: Mon, 13 Dec 1999 18:31:43 +0100 From: Ivo Simicevic To: Edouard DESSIOUX Cc: pgsql-interfaces@postgreSQL.org Subject: Re: [INTERFACES] Table or not table ? Message-ID: <19991213183143.B1280@ultra.hr> References: <99121317261008.01232@dooz.corp.intrinsec.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/0.95.7i In-Reply-To: <99121317261008.01232@dooz.corp.intrinsec.com> Sender: ivo@punta.ultra.hr On Mon, Dec 13, 1999 at 05:23:59PM +0100, Edouard DESSIOUX wrote: > Hello > > I wanted to be sure that a table exist before > making a request such as "select * from $table" > because it display something like > > Warning: PostgresSQL query failed: > ERROR: prout: Table does not exist. in > /www/dooz.corp.intrinsec.com/tableau.php3 on line 15 > > Does anyone know what i could do to verify that > the table exist, or help to disable error messages > on web pages ? > > Bye > > -- Try select * from pg_tables where tablename="wanted_table"; Ivo.