On Wed, Mar 05, 2003 at 02:09:03PM -0500, Kevin Coyner wrote......
>
> 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?
No thoughts about this one?
Thanks
Kevin
--
Kevin Coyner
mailto: kevin(at)rustybear(dot)com
GnuPG key: 1024D/8CE11941