Re: IF EXISTS - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: IF EXISTS
Date
Msg-id 20060921054540.GB4698@merkur.hilbert.loc
Whole thread Raw
In response to Re: IF EXISTS  (Jeff Davis <pgsql@j-davis.com>)
List pgsql-general
On Wed, Sep 20, 2006 at 04:12:16PM -0700, Jeff Davis wrote:

> In 8.2, which is currently still in production, they have added the
> feature where you can do things like:
>
> DROP SEQUENCE IF EXISTS mysequence;
> CREATE SEQUENCE mysequence;
>
> Which makes writing SQL scripts much easier. They also made it work for
> other objects, like DROP TABLE IF EXISTS, etc.
Hurra !

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: column names in select don't exists in insert to
Next
From: "Harald Armin Massa"
Date:
Subject: Re: postgresql rising