use this table: http://www.postgresql.org/docs/8.3/static/catalog-pg-constraint.html to check if it exists.
On Wed, Apr 20, 2011 at 12:46 PM, Lukasz Brodziak <lukasz.brodz...@gmail.com > wrote: > Hello, > > Is there a way of dropping a FK only if it exists. The thing is that I > don't know if client has this FK on the table or not. > > -- > Łukasz Brodziak > "What if everyting around You isn't quite as it seems, > What if all the world You think You know is an inelaborate dream > When You look at Your reflection is that all you want it to be > What if You could look right through the cracks > Would You find Yourself...... Find Yourself afraid to see" > > -- > Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-admin > -- --------------------------------------- Viktor Bojović --------------------------------------- Wherever I go, Murphy goes with me
