drop table before create

Hi ..

I have not been able to work out how to do this is Postgres 8
(pseudo-code)

if exists table foo
drop table foo;
end
create table foo;

If I go with

drop table foo;
create table foo;

then it barfs on an empty db. I can find the table name in pg_class but
I am not sure of where to go from there.

The assumption here is that the SQL is coming in on a script via the
programmatic interface. Slurp in a bunch of SQL commands and then fire
them at the database.

Perhaps it is just easier to 'dropdb' then 'createdb' and go from there.

Many thanks,

--
-mark. (probertm at acm dot org)