drop table if exists - Mailing list pgsql-novice

From Kevin Coyner
Subject drop table if exists
Date
Msg-id 20030305190903.GA20607@rustybear.com
Whole thread Raw
Responses Re: drop table if exists  (Kevin Coyner <kevin@rustybear.com>)
List pgsql-novice
In MySQL, when I create a new table from a .sql file, I usually start
with:

DROP TABLE IF EXISTS sometable;
CREATE TABLE sometable(


This doesn't work in Postgres and I haven't been able to find the
equivalent in the docs.  If I try to drop a table that doesn't exist, I
get an error message, so having that modifier "... if exists ..." is
nice.

Is there an equivalent to "IF EXISTS" in Postgres?

Hoping someone can steer me in the right direction.

Thanks
Kevin

--
Kevin Coyner
mailto: kevin@rustybear.com
GnuPG key: 1024D/8CE11941

pgsql-novice by date:

Previous
From: glenn
Date:
Subject: ALTER TABLE DROP COLUMN
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE DROP COLUMN