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])

Reply via email to