Postgres Pro
Downloads
Home   >   mailing lists

Re: end of COPY - Mailing list pgsql-general

From Marc Millas
Subject Re: end of COPY
Date
Msg-id CADX_1aYnt5sNG6G4vCUgY+NnzoLEN57LB5vKBtgKtg8k9qZYzw@mail.gmail.com
Whole thread Raw
In response to Re: end of COPY  (Greg Sabino Mullane <htamfids@gmail.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Quesion about querying distributed databases
Next
From: mark bradley
Date:
Subject: Duplicate Key Values