On Sat, 18 Oct 2003, Sam Carleton wrote:
> I am working on creating my first database in Postgres. In the
> script that will create all the tables for the firs time, I would
> like to have a conditional statement to delete a table, if it
> already exists.
As far as I know, there is no way to do that in PostgreSQL's standard
SQL language. But it doesn't matter -- as long as the DROP TABLE
command is in it's own transaction, you can unconditionally drop the table
and ignore any errors.
Regards,
David.