Hello, Is there a way of disabling/dropping all constrainsts in a given database? I need to restore a db which has duplicate values in nearly half of its tables then remove duplicates and then add the constraints back. Is there a way to do that for each table in one statement/function? It may be even a java/perl script if it can do such a thing. Thank You all in advance for help. -- Å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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin