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. ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])