[ADMIN] Dropping all constraints in database

2011-03-14 Thread Lukasz Brodziak
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 e

Re: [ADMIN] Dropping all constraints in database

2011-03-14 Thread Thomas Kellerer
Lukasz Brodziak, 14.03.2011 10:26: 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 i

Re: [ADMIN] Dropping all constraints in database

2011-03-14 Thread Glyn Astill
> From: Lukasz Brodziak > Subject: [ADMIN] Dropping all constraints in database > To: pgsql-admin@postgresql.org > Date: Monday, 14 March, 2011, 9:26 > Hello, > > Is there a way of disabling/dropping all constrainsts in a > given > database? I need to restore a db