Re: Multiple tables row insertions from single psql input file

On Mon, Jun 10, 2024 at 5:16 PM David G. Johnston <
david(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> 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?
>

I mentioned bulk loading of data. Occasionally that's useful, even in a
prod database.