Message-ID: <371F0FC1.DF690C47@sferacarta.com>
Date: Thu, 22 Apr 1999 14:02:09 +0200
From: =?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
MIME-Version: 1.0
To: "Brett W. McCoy" <bmccoy@lan2wan.com>
CC: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Detecting existance of table
References: <Pine.BSI.3.91.990421184714.10411U-100000@access1.lan2wan.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Try this:
 select TRUE from pg_class where relname = 'my_table' and relkind = 'r';

José


"Brett W. McCoy" ha scritto:

> Is there a way of detecting the existance of a table via a function call?
> I'm trying to implement a 'saved search' feature in a search engine, and
> need to query a database to see if a particular table exists without
> throwing an error.  Actually, can an exception be caught somehow?  I'm
> mainly doing this with PHP3, but I also need to do it via the Perl Pg.pm
>
> Brett W. McCoy
>                                          http://www.lan2wan.com/~bmccoy
> -----------------------------------------------------------------------
> Why is the alphabet in that order?  Is it because of that song?