MIME-Version: 1.0
References: <CAEZv3cqEZyUouS_0tCcUG1UOi6C0VcYLgoneq-Atf8i+ikge1A@mail.gmail.com>
In-Reply-To: <CAEZv3cqEZyUouS_0tCcUG1UOi6C0VcYLgoneq-Atf8i+ikge1A@mail.gmail.com>
From: Francisco Olarte <folarte@peoplecall.com>
Date: Mon, 16 Sep 2024 17:51:28 +0200
Message-ID: <CA+bJJbzkpHw9n=_pb1vDukgty1_r6pjt1F9=MniVAYkiVjfdPA@mail.gmail.com>
Subject: Re: load fom csv
To: Andy Hartman <hartman60home@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000f4520506223e8d8c"
Archived-At: <https://www.postgresql.org/message-id/CA%2BbJJbzkpHw9n%3D_pb1vDukgty1_r6pjt1F9%3DMniVAYkiVjfdPA%40mail.gmail.com>
Precedence: bulk

--000000000000f4520506223e8d8c
Content-Type: text/plain; charset="UTF-8"

On Mon, 16 Sept 2024 at 17:36, 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 =
> "Host=$pgServer;Database=$pgDatabase;Username=$pgUser;Password=$pgPassword"
> $copyCommand = "\COPY $pgTable FROM '$csvPath' DELIMITER ',' CSV HEADER;"
> psql -h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand
> how can I debug this?
>

I would start by adding -a and -e after "psql".

IIRC Powershell is windows, and in windows shell do not pass command words
preparsed as in *ix to the executable, but a single command line with the
executable must parse. Given the amount of quoting, -a and -e will let you
see the commands are properly sent, and if it is trying to read something
what it is.

I will also try to substitute the -c with a pipe. If it heals, it is
probably a quoting issue.

Also, I just caught Ron's message, and psql might be waiting for a password.

Francisco Olarte.

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

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:monospace,monospace"><br></div></div><br><div class=3D"gmail_quote=
"><div dir=3D"ltr" class=3D"gmail_attr">On Mon, 16 Sept 2024 at 17:36, Andy=
 Hartman &lt;<a href=3D"mailto:hartman60home@gmail.com" target=3D"_blank">h=
artman60home@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_q=
uote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,2=
04);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">I&#39;m trying to r=
un this piece of code from Powershell and it just sits there and never come=
s back. There are only 131 records in the csv.<br><div>$connectionString =
=3D &quot;Host=3D$pgServer;Database=3D$pgDatabase;Username=3D$pgUser;Passwo=
rd=3D$pgPassword&quot;</div><div>$copyCommand =3D &quot;\COPY $pgTable FROM=
 &#39;$csvPath&#39; DELIMITER &#39;,&#39; CSV HEADER;&quot;</div><div>psql =
-h $pgServer -d $pgDatabase -U $pgUser -c $copyCommand=C2=A0</div><div>how =
can I debug this?=C2=A0=C2=A0</div></div></div></blockquote><div><br></div>=
<div><div style=3D"font-family:monospace,monospace" class=3D"gmail_default"=
>I would start by adding -a and -e after &quot;psql&quot;.</div><div style=
=3D"font-family:monospace,monospace" class=3D"gmail_default"><br></div><div=
 style=3D"font-family:monospace,monospace" class=3D"gmail_default">IIRC Pow=
ershell is windows, and in windows shell do not pass command words preparse=
d as in *ix to the executable, but a single command line with the executabl=
e must parse. Given the amount of quoting, -a and -e will let you see the c=
ommands are properly sent, and if it is trying to read something what it is=
.<br></div><div style=3D"font-family:monospace,monospace" class=3D"gmail_de=
fault"><br></div><div style=3D"font-family:monospace,monospace" class=3D"gm=
ail_default">I will also try to substitute the -c with a pipe. If it heals,=
 it is probably a quoting issue.</div><div style=3D"font-family:monospace,m=
onospace" class=3D"gmail_default"><br></div><div style=3D"font-family:monos=
pace,monospace" class=3D"gmail_default">Also, I just caught Ron&#39;s messa=
ge, and psql might be waiting for a password.<br></div><div style=3D"font-f=
amily:monospace,monospace" class=3D"gmail_default"><br></div><div style=3D"=
font-family:monospace,monospace" class=3D"gmail_default">Francisco Olarte.<=
/div></div><br></div></div>

--000000000000f4520506223e8d8c--