Re: if exists / where exisyts....

On Fri, 2002-05-24 at 09:12, Denis Cartier Millon wrote:
> i want to test if a table exists before to drop this......
>
> the :
> if exists (select 1 from pg_tables where tablename = "thetable")
> drop table thetable
> ;
>
> don't work....

I'd use the system catalogs:
test2=# select count(*) from pg_class where relname = 'foo';
count
-------
1
(1 row)

test2=# select count(*) from pg_class where relname = 'snaggle';
count
-------
0
(1 row)

You can use it for tables, views, indexes (and maybe other
things).

--
+---------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA http://ronandheather.dhs.org:81 |
| |
| "I have created a government of whirled peas..." |
| Maharishi Mahesh Yogi, 12-May-2002, |
! CNN, Larry King Live |
+---------------------------------------------------------+