Re: end of COPY

2025-03-05 Thread Marc Millas
Greg... 👍 works fine now. thanks ! Marc MILLAS Senior Architect +33607850334 www.mokadb.com On Wed, Mar 5, 2025 at 4:53 PM Greg Sabino Mullane wrote: > On Wed, Mar 5, 2025 at 10:22 AM Marc Millas > wrote: > >> Then the flow contains a single line: \. to my understanding this means >> end

Re: end of COPY

2025-03-05 Thread Ron Johnson
On Wed, Mar 5, 2025 at 10:53 AM Greg Sabino Mullane wrote: > On Wed, Mar 5, 2025 at 10:22 AM Marc Millas > 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 >> "\."

Re: end of COPY

2025-03-05 Thread Adrian Klaver
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 t

Re: end of COPY

2025-03-05 Thread Greg Sabino Mullane
On Wed, Mar 5, 2025 at 10:22 AM Marc Millas 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 tha

Re: end of COPY

2025-03-05 Thread Ron Johnson
On Wed, Mar 5, 2025 at 10:22 AM 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