public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Multiple tables row insertions from single psql input file
Date: Mon, 10 Jun 2024 16:25:54 -0400
Message-ID: <CANzqJaBiwqb_9c-+Ot1YL3UtQsrDb9K7RO0unD2r3jFH7uxNSA@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com>
<[email protected]>
On Mon, Jun 10, 2024 at 4:06 PM Rich Shepard <[email protected]>
wrote:
> On Mon, 10 Jun 2024, Ron Johnson wrote:
>
> > With enough clever scripting you can create a .sql file that does almost
> > anything.
>
> Ron,
>
> My projects don't all use SQL so I'm far from a clever scripter. :-)
>
No one is born a scripter, much less a clever scripter.
> > 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.
>
> Doesn't alter table primarily apply to existing row values for specific
> columns rather than inserting new rows and their column values?
>
I don't think so. For example, pg_dump has an option to add those
DISABLE/ENABLE TRIGGER statements. It makes bulk loading of records much
simpler.
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected]
Subject: Re: Multiple tables row insertions from single psql input file
In-Reply-To: <CANzqJaBiwqb_9c-+Ot1YL3UtQsrDb9K7RO0unD2r3jFH7uxNSA@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox