MIME-Version: 1.0
References: <7da8ec9-089-74ce-eb3-c88889b62c64@appl-ecosys.com>
 <CANzqJaAXnwh-n0K_JhGiGja2vdqFvRvffdwe2RkVAVKLbmH69g@mail.gmail.com> <c6b1b533-175f-3378-b749-221d97e41562@appl-ecosys.com>
In-Reply-To: <c6b1b533-175f-3378-b749-221d97e41562@appl-ecosys.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 10 Jun 2024 16:25:54 -0400
Message-ID: <CANzqJaBiwqb_9c-+Ot1YL3UtQsrDb9K7RO0unD2r3jFH7uxNSA@mail.gmail.com>
Subject: Re: Multiple tables row insertions from single psql input file
To: pgsql-general <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000679874061a8ef5d1"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaBiwqb_9c-%2BOt1YL3UtQsrDb9K7RO0unD2r3jFH7uxNSA%40mail.gmail.com>
Precedence: bulk

--000000000000679874061a8ef5d1
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Jun 10, 2024 at 4:06=E2=80=AFPM Rich Shepard <rshepard@appl-ecosys.=
com>
wrote:

> On Mon, 10 Jun 2024, Ron Johnson wrote:
>
> > With enough clever scripting you can create a .sql file that does almos=
t
> > 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 "ALT=
ER
> > 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.

--000000000000679874061a8ef5d1
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Jun 10, 2024 at 4:06=E2=80=AFPM R=
ich Shepard &lt;<a href=3D"mailto:rshepard@appl-ecosys.com">rshepard@appl-e=
cosys.com</a>&gt; wrote:<br></div><div class=3D"gmail_quote"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">On Mon, 10 Jun 2024, Ron Johnson wrote:=
<br>
<br>
&gt; With enough clever scripting you can create a .sql file that does almo=
st<br>
&gt; anything.<br>
<br>
Ron,<br>
<br>
My projects don&#39;t all use SQL so I&#39;m far from a clever scripter. :-=
)<br></blockquote><div><br></div><div>No one is born a scripter, much less =
a clever scripter.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);pa=
dding-left:1ex">&gt; Most useful to you will be some number of &quot;ALTER =
TABLE &lt;foo&gt; DISABLE<br>
&gt; TRIGGER ALL;&quot; statements near the beginning of the file, and thei=
r &quot;ALTER<br>
&gt; TABLE ... ENABLE TRIGGER ALL;&quot; counterparts near the end of the f=
ile.<br>
<br>
Doesn&#39;t alter table primarily apply to existing row values for specific=
<br>
columns rather than inserting new rows and their column values?<br></blockq=
uote><div><br></div><div>I don&#39;t think=C2=A0so.=C2=A0 For example, pg_d=
ump has an option to add those DISABLE/ENABLE TRIGGER=C2=A0 statements.=C2=
=A0 It makes bulk loading of records much simpler.</div><div><br></div></di=
v></div>

--000000000000679874061a8ef5d1--