Re: Dropping all constraints in database

> From: Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com>
> Subject: [ADMIN] Dropping all constraints in database
> To: pgsql-admin(at)postgresql(dot)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 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.
>
>

Magnus Hagander wrote about a method to do that here:

http://blog.hagander.net/archives/131-Automatically-dropping-and-creating-constraints.html