Postgres Pro
Downloads
Home   >   mailing lists

Re: end of COPY - Mailing list pgsql-general

From Ron Johnson
Subject Re: end of COPY
Date
Msg-id CANzqJaCW48poyRujU_vzdO1UwbhqHyXiWgt1sRtLxpWKc5W++A@mail.gmail.com
Whole thread Raw
In response to end of COPY  (Marc Millas <marc.millas@mokadb.com>)
List pgsql-general
Tree view
On Wed, Mar 5, 2025 at 10:22 AM 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;"
 
"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.

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

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: end of COPY
Next
From: Greg Sabino Mullane
Date:
Subject: Re: end of COPY