if exists / where exisyts.... - Mailing list pgsql-interfaces

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 try :

wher e exists (....)
;

don't work.


but the expresssion :
select * from pg_tables where exists(select 1 from pg_tables where 
tablename = "thetable")
;

work