MIME-Version: 1.0
From: Marc Millas <marc.millas@mokadb.com>
Date: Wed, 5 Mar 2025 16:22:30 +0100
Message-ID: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
Subject: end of COPY
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000f3db78062f99f503"
Archived-At: <https://www.postgresql.org/message-id/CADX_1abY%3DD3o4Env3kzUnuMarBKt%2BiwAiVvfHiVZrhgMit6KkQ%40mail.gmail.com>
Precedence: bulk

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

Hi,
on a Postgres 16 DB running on a redhat 8.5 x86 machineI want to input some
data using copy from stdin
so.. more that 700 000 lines goes well.
Then the flow contains a single line: \.
to my understanding this means end of the copy

but, Postgres generates an error :
invalid input syntax for type numeric "\."
then the 2 lines stating the copy command that was executed.

what am I missing ?

thanks


Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

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

<div dir=3D"ltr"><div>Hi,</div><div>on a Postgres 16 DB running on a redhat=
=C2=A08.5 x86 machineI want to input some data using=C2=A0copy from stdin</=
div><div>so.. more that 700 000 lines goes well.</div><div>Then the flow co=
ntains a single line: \.</div><div>to my understanding this means end of th=
e copy=C2=A0</div><div><br></div><div>but, Postgres generates an error=C2=
=A0:</div><div>invalid input syntax for type numeric &quot;\.&quot;</div><d=
iv>then the 2 lines stating the copy command that was executed.</div><div><=
br></div><div>what am I missing ?</div><div><br></div><div>thanks</div><div=
><br></div><div><br></div><div><div dir=3D"ltr" class=3D"gmail_signature" d=
ata-smartmail=3D"gmail_signature"><div dir=3D"ltr"><div><div dir=3D"ltr">Ma=
rc MILLAS<div>Senior Architect</div><div>+33607850334</div><div><a href=3D"=
http://www.mokadb.com" target=3D"_blank">www.mokadb.com</a></div><div><br><=
/div></div></div></div></div></div></div>

--000000000000f3db78062f99f503--