MIME-Version: 1.0
References: <CAEZv3cqEZyUouS_0tCcUG1UOi6C0VcYLgoneq-Atf8i+ikge1A@mail.gmail.com>
In-Reply-To: <CAEZv3cqEZyUouS_0tCcUG1UOi6C0VcYLgoneq-Atf8i+ikge1A@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Mon, 16 Sep 2024 11:47:16 -0400
Message-ID: <CANzqJaAm_SmiSZ63AfKUz8Wv=htBpJ-OhXwLvQSiGg+xpmVPWQ@mail.gmail.com>
Subject: Re: load fom csv
To: "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000060ae2606223e7d00"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAm_SmiSZ63AfKUz8Wv%3DhtBpJ-OhXwLvQSiGg%2BxpmVPWQ%40mail.gmail.com>
Precedence: bulk

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

On Mon, Sep 16, 2024 at 11:36=E2=80=AFAM Andy Hartman <hartman60home@gmail.=
com>
wrote:

> I'm trying to run this piece of code from Powershell and it just sits
> there and never comes back. There are only 131 records in the csv.
>
> $connectionString =3D
> "Host=3D$pgServer;Database=3D$pgDatabase;Username=3D$pgUser;Password=3D$p=
gPassword"
> $copyCommand =3D "\COPY $pgTable FROM '$csvPath' DELIMITER ',' CSV HEADER=
;"
>
> psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand
>
> how can I debug this?
>

Maybe I'm missing something obvious, but where in the psql command are you
using $connectionString?

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

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

<div dir=3D"ltr"><div dir=3D"ltr"><br></div><br><div class=3D"gmail_quote">=
<div dir=3D"ltr" class=3D"gmail_attr">On Mon, Sep 16, 2024 at 11:36=E2=80=
=AFAM Andy Hartman &lt;<a href=3D"mailto:hartman60home@gmail.com">hartman60=
home@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" st=
yle=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padd=
ing-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">I&#39;m trying to run this =
piece of code from Powershell and it just sits there and never comes back. =
There are only 131 records in the csv.<br><br><div>$connectionString =3D &q=
uot;Host=3D$pgServer;Database=3D$pgDatabase;Username=3D$pgUser;Password=3D$=
pgPassword&quot;</div><div>$copyCommand =3D &quot;\COPY $pgTable FROM &#39;=
$csvPath&#39; DELIMITER &#39;,&#39; CSV HEADER;&quot;</div><div><br></div><=
div>psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand=C2=A0</div>=
<div><br></div><div>how can I debug this?=C2=A0=C2=A0</div></div></div></bl=
ockquote></div><div><br></div><div>Maybe I&#39;m missing=C2=A0something obv=
ious, but where in the psql command are you using $connectionString?</div><=
div><br></div><span class=3D"gmail_signature_prefix">-- </span><br><div dir=
=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to &lt;Redacted&g=
t;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><div><=
div>&lt;Redacted&gt; crustacean!</div></div></div></div></div></div>

--00000000000060ae2606223e7d00--