Re: Conditional Statement

"Samik Raychauhduri" <samik(at)cae(dot)wisc(dot)edu> wrote in message news:3C82CA4C(dot)6030205(at)cae(dot)wisc(dot)edu(dot)(dot)(dot)
> I am trying to write a piece of SQL code, which will first check if a
> table exist, drop it and then recreate it. I didn't see any 'IF' syntax
> in pgsql. Is there any other alternative? I tried to use 'case'
> structure, but didn't succeed.

The way you do that is to say:

drop table foo
create table foo ...

That's all you need. Nothing fancy. The 'drop table' will print a message
if the table didn't exist already, but it doesn't matter.

Marshall