Re: [INTERFACES] Detecting existance of table

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?