In MySQL, when I create a new table from a .sql file, I usually start
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
Is there an equivalent to "IF EXISTS" in Postgres?
Hoping someone can steer me in the right direction.
GnuPG key: 1024D/8CE11941
pgsql-novice by date
|Next:||From: Tom Lane||Date: 2003-03-05 21:38:00|
|Subject: Re: ALTER TABLE DROP COLUMN |
|Previous:||From: glenn||Date: 2003-03-05 18:03:02|
|Subject: ALTER TABLE DROP COLUMN|