Re: Multiple tables row insertions from single psql input file

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Multiple tables row insertions from single psql input file
Date: 2024-06-10 21:15:36
Message-ID: CAKFQuwbGedOO=iq9uC1e7FEbURvuFh1CHXrEZ-uF1mSt2+scyQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> On Mon, Jun 10, 2024 at 12:43 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2024-06-10 21:27:15 Re: Multiple tables row insertions from single psql input file
Previous Message Adrian Klaver 2024-06-10 20:52:53 Re: Escaping single quotes with backslash seems not to work