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 CANzqJaCCNYWN53TuCnp2fV-cR5SHDNRwibONM_6gDVP3pL8BDw@mail.gmail.com
Whole thread Raw
In response to Re: end of COPY  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general
Tree view
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!

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: end of COPY
Next
From: Adrian Klaver
Date:
Subject: Re: Quesion about querying distributed databases