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

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

2024-09-16 12:06:00.968 EDT [4968] ERROR:  relation
"image_classification_master" does not exist
2024-09-16 12:06:00.968 EDT [4968] STATEMENT:  COPY
Image_Classification_Master FROM STDIN DELIMITER ',' CSV HEADER;

On Mon, Sep 16, 2024 at 11:52=E2=80=AFAM Francisco Olarte <folarte@peopleca=
ll.com>
wrote:

>
>
> 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 =3D
>> "Host=3D$pgServer;Database=3D$pgDatabase;Username=3D$pgUser;Password=3D$=
pgPassword"
>> $copyCommand =3D "\COPY $pgTable FROM '$csvPath' DELIMITER ',' CSV HEADE=
R;"
>> 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 word=
s
> 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 yo=
u
> 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.
>
>

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

<div dir=3D"ltr"><div dir=3D"ltr"><div><span style=3D"white-space:normal">	=
</span></div><div>2024-09-16 12:06:00.968 EDT [4968] ERROR:=C2=A0 relation =
&quot;image_classification_master&quot; does not exist</div><div>2024-09-16=
 12:06:00.968 EDT [4968] STATEMENT:=C2=A0 COPY=C2=A0 Image_Classification_M=
aster FROM STDIN DELIMITER &#39;,&#39; CSV HEADER;=C2=A0</div></div></div><=
br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Mon,=
 Sep 16, 2024 at 11:52=E2=80=AFAM Francisco Olarte &lt;<a href=3D"mailto:fo=
larte@peoplecall.com">folarte@peoplecall.com</a>&gt; wrote:<br></div><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"lt=
r"><div class=3D"gmail_default" style=3D"font-family:monospace,monospace"><=
br></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gma=
il_attr">On Mon, 16 Sept 2024 at 17:36, Andy Hartman &lt;<a href=3D"mailto:=
hartman60home@gmail.com" target=3D"_blank">hartman60home@gmail.com</a>&gt; =
wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0=
px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir=
=3D"ltr"><div dir=3D"ltr">I&#39;m trying to run this piece of code from Pow=
ershell and it just sits there and never comes back. There are only 131 rec=
ords in the csv.<br><div>$connectionString =3D &quot;Host=3D$pgServer;Datab=
ase=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>psql -h $pgServer -d $pgDatabase -U $=
pgUser -c $copyCommand=C2=A0</div><div>how can I debug this?=C2=A0=C2=A0</d=
iv></div></div></blockquote><div><br></div><div><div style=3D"font-family:m=
onospace,monospace" class=3D"gmail_default">I would start by adding -a and =
-e after &quot;psql&quot;.</div><div style=3D"font-family:monospace,monospa=
ce" class=3D"gmail_default"><br></div><div style=3D"font-family:monospace,m=
onospace" class=3D"gmail_default">IIRC Powershell is windows, and in window=
s shell do not pass command words preparsed as in *ix to the executable, bu=
t 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.<br></div><div style=3D"font-fam=
ily:monospace,monospace" class=3D"gmail_default"><br></div><div style=3D"fo=
nt-family:monospace,monospace" class=3D"gmail_default">I will also try to s=
ubstitute the -c with a pipe. If it heals, it is probably a quoting issue.<=
/div><div style=3D"font-family:monospace,monospace" class=3D"gmail_default"=
><br></div><div style=3D"font-family:monospace,monospace" class=3D"gmail_de=
fault">Also, I just caught Ron&#39;s message, and psql might be waiting for=
 a password.<br></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">Francisco Olarte.</div></div><br></div></div>
</blockquote></div>

--000000000000f207aa06223ed52e--