Re: end of COPY

[Ron Johnson <ronljohnsonjr@xxxxxxxxx>]

On Wed, Mar 5, 2025 at 10:22 AM Marc Millas <marc.millas@xxxxxxxxxx> 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.

--

Death to <Redacted>, and butter sauce.

Don't boil me, I'm still alive.

<Redacted> lobster!