How can I set all constraints to be deferrable for a DB/schema

From: David Gauthier <davegauthierpg(at)gmail(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: How can I set all constraints to be deferrable for a DB/schema
Date: 2020-03-18 03:14:03
Message-ID: CAMBRECDt3pJwNxC95n1vqu8dm1nA82KU+BesUY_THDCWWMddTg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi:

psql (9.6.7, server 11.3) (linux)

Is there a way to set all constraints on all tables of a DB and/or schema
to be deferrable ? Or do I have to do them one-by-one ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Westermann (DWE) 2020-03-18 07:17:16 Re: Temporary tablespaces on a RAM disk
Previous Message Michael Paquier 2020-03-18 02:25:25 Re: Mixed Locales and Upgrading