public inbox for [email protected]  

help / color / mirror / Atom feed

From: Adrian Klaver <[email protected]>
To: Marc Millas <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: end of COPY
Date: Wed, 5 Mar 2025 07:55:03 -0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>
References: <CADX_1abY=D3o4Env3kzUnuMarBKt+iwAiVvfHiVZrhgMit6KkQ@mail.gmail.com>

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
[email protected]

view thread (5+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: end of COPY
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox