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?