MIME-Version: 1.0
References: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
In-Reply-To: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Wed, 5 Mar 2025 10:40:33 -0500
Message-ID: <CANzqJaCW48poyRujU_vzdO1UwbhqHyXiWgt1sRtLxpWKc5W++A@mail.gmail.com>
Subject: Re: end of COPY
To: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000006cfbce062f9a36df"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCW48poyRujU_vzdO1UwbhqHyXiWgt1sRtLxpWKc5W%2B%2BA%40mail.gmail.com>
Precedence: bulk

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

On Wed, Mar 5, 2025 at 10:22=E2=80=AFAM Marc Millas <marc.millas@mokadb.com=
> wrote:

> 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
>

I just tested this on PG 16.8.  No backslash.
$ psql TAP -Xc "copy public.job_notification TO STDOUT;"

https://www.postgresql.org/docs/16/sql-copy.html
"End of data *can be* represented by a single line containing just
backslash-period (\.)."
"the end-of-data marker (\.) or the null string (\N by default)."


> 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 ?
>

COPY is expecting something after the backslash.

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

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

<div dir=3D"ltr"><div dir=3D"ltr">On Wed, Mar 5, 2025 at 10:22=E2=80=AFAM M=
arc Millas &lt;<a href=3D"mailto:marc.millas@mokadb.com">marc.millas@mokadb=
.com</a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><=
blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l=
eft:1px solid rgb(204,204,204);padding-left:1ex"><div dir=3D"ltr"><div>Hi,<=
/div><div>on a Postgres 16 DB running on a redhat=C2=A08.5 x86 machineI wan=
t to input some data using=C2=A0copy from stdin</div><div>so.. more that 70=
0 000 lines goes well.</div><div>Then the flow contains a single line: \.</=
div><div>to my understanding this means end of the copy=C2=A0</div></div></=
blockquote><div><br></div><div>I just tested this on PG 16.8.=C2=A0 No back=
slash.</div><div>$ psql TAP -Xc &quot;copy public.job_notification TO STDOU=
T;&quot;</div><div>=C2=A0</div><div><a href=3D"https://www.postgresql.org/d=
ocs/16/sql-copy.html">https://www.postgresql.org/docs/16/sql-copy.html</a><=
/div><div><span style=3D"color:rgb(0,0,0);font-family:&quot;Open Sans&quot;=
,sans-serif;font-size:14.4px">&quot;End of data <b>can be</b> represented b=
y a single line containing just backslash-period (</span><code class=3D"gma=
il-literal" style=3D"box-sizing:border-box;font-family:monospace,monospace;=
font-size:14.4px;color:rgb(0,0,0);border-radius:0.25rem;margin:0.6rem 0px">=
\.</code><span style=3D"color:rgb(0,0,0);font-family:&quot;Open Sans&quot;,=
sans-serif;font-size:14.4px">).&quot;</span></div><div><span style=3D"color=
:rgb(0,0,0);font-family:&quot;Open Sans&quot;,sans-serif;font-size:14.4px">=
&quot;the end-of-data marker (</span><code class=3D"gmail-literal" style=3D=
"box-sizing:border-box;font-family:monospace,monospace;font-size:14.4px;col=
or:rgb(0,0,0);border-radius:0.25rem;margin:0.6rem 0px">\.</code><span style=
=3D"color:rgb(0,0,0);font-family:&quot;Open Sans&quot;,sans-serif;font-size=
:14.4px">) or the null string (</span><code class=3D"gmail-literal" style=
=3D"box-sizing:border-box;font-family:monospace,monospace;font-size:14.4px;=
color:rgb(0,0,0);border-radius:0.25rem;margin:0.6rem 0px">\N</code><span st=
yle=3D"color:rgb(0,0,0);font-family:&quot;Open Sans&quot;,sans-serif;font-s=
ize:14.4px">=C2=A0by default).&quot;</span><span style=3D"color:rgb(0,0,0);=
font-family:&quot;Open Sans&quot;,sans-serif;font-size:14.4px"></span></div=
><div><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><br></div><div>but, Postgres generates an error=C2=A0:</div><=
div>invalid input syntax for type numeric &quot;\.&quot;</div><div>then the=
 2 lines stating the copy command that was executed.</div><div><br></div><d=
iv>what am I missing ?</div></div></blockquote><div></div></div><div><br cl=
ear=3D"all"></div><div>COPY is expecting something after the backslash.</di=
v><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;Redacte=
d&gt;, and butter sauce.<div>Don&#39;t boil me, I&#39;m still alive.<br><di=
v><div>&lt;Redacted&gt; lobster!</div></div></div></div></div></div>

--0000000000006cfbce062f9a36df--