Postgres Pro
Downloads
Home   >   mailing lists

Thread: end of COPY

end of COPY

From
Marc Millas
Date:
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

Re: end of COPY

From
Ron Johnson
Date:
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!

Re: end of COPY

From
Greg Sabino Mullane
Date:
On Wed, Mar 5, 2025 at 10:22 AM Marc Millas <marc.millas@mokadb.com> wrote:
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 "\."

This can happen when you send TWO backslashes and a dot, rather than a single backslash and a dot.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

Re: end of COPY

From
Adrian Klaver
Date:
On 3/5/25 07:22, Marc Millas 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

Provide the lines at the end of the data.

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

Provide the complete error message.

> 
> what am I missing ?
> 
> thanks
> 
> 
> Marc MILLAS
> Senior Architect
> +33607850334
> www.mokadb.com <http://www.mokadb.com>
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com

Re: end of COPY

From
Ron Johnson
Date:
On Wed, Mar 5, 2025 at 10:53 AM Greg Sabino Mullane <htamfids@gmail.com> wrote:
On Wed, Mar 5, 2025 at 10:22 AM Marc Millas <marc.millas@mokadb.com> wrote:
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 "\."

This can happen when you send TWO backslashes and a dot, rather than a single backslash and a dot.

I hate proportional fonts. 😠

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

Re: end of COPY

From
Marc Millas
Date:
Greg... 👍

works fine now.

thanks !


Marc MILLAS
Senior Architect
+33607850334



On Wed, Mar 5, 2025 at 4:53 PM Greg Sabino Mullane <htamfids@gmail.com> wrote:
On Wed, Mar 5, 2025 at 10:22 AM Marc Millas <marc.millas@mokadb.com> wrote:
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 "\."

This can happen when you send TWO backslashes and a dot, rather than a single backslash and a dot.

Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support