Re: conditional alter table - Mailing list pgsql-general

From Chris
Subject Re: conditional alter table
Date
Msg-id 484340C0.6020507@gmail.com
Whole thread Raw
In response to conditional alter table  (Brian Cox <brian.cox@ca.com>)
List pgsql-general
Brian Cox wrote:
> I'd like to either 1) execute an alter table to re-add a constraint only
> if it doesn't exist or 2) have psql ignore the failure when setting it's
> exit status.  Any ideas on how to do either would be appreciated.

I don't think there's a way to do that but you can look at the
pg_constraint table to see if it exists.

http://www.postgresql.org/docs/current/static/catalog-pg-constraint.html
--
Postgresql & php tutorials
http://www.designmagick.com/

pgsql-general by date:

Previous
From: Chris
Date:
Subject: Re: phpeclipse debugging & setup
Next
From: "J. Manuel Velasco"
Date:
Subject: HELP with a query with blank fields