Re: Multiple tables row insertions from single psql input file - Mailing list pgsql-general

From David G. Johnston
Subject Re: Multiple tables row insertions from single psql input file
Date
Msg-id CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com
Whole thread Raw
In response to Re: Multiple tables row insertions from single psql input file  (Ron Johnson <ronljohnsonjr@gmail.com>)
Responses Re: Multiple tables row insertions from single psql input file
List pgsql-general
On Mon, Jun 10, 2024 at 12:43 PM Ron Johnson <ronljohnsonjr@gmail.com> wrote:

Most useful to you will be some number of "ALTER TABLE <foo> DISABLE TRIGGER ALL;" statements near the beginning of the file, and their "ALTER TABLE ... ENABLE TRIGGER ALL;" counterparts near the end of the file.


Have you just not heard of deferred constraints or is there some reason besides deferring constraints that you'd want to use alter table in transactional production code?

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Escaping single quotes with backslash seems not to work
Next
From: "Peter J. Holzer"
Date:
Subject: Re: Multiple tables row insertions from single psql input file