Date: Thu, 14 Dec 2023 09:08:34 +0100
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: =?utf-8?B?6auY5Y2H?= <13325718563@189.cn>
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: about psql copy ,we would like to seek help,Thanks.
Message-ID: <ZXq4AkBCn1bHfE-8@depesz.com>
Reply-To: depesz@depesz.com
References: <000301da2e29$8d2a7e00$a77f7a00$@cn>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: <000301da2e29$8d2a7e00$a77f7a00$@cn>
Archived-At: 
 <https://www.postgresql.org/message-id/ZXq4AkBCn1bHfE-8%40depesz.com>
Precedence: bulk

On Thu, Dec 14, 2023 at 09:04:55AM +0800, 高升 wrote:
> We have looked at some tutorials, and it seems that we can use the
> "CONTINUE" option. By using the CONTINUE option, the COPY command should
> ignore error rows and continue with the copying operation until all rows are
> copied. The relevant error information for the error rows will be recorded. 

I searched the web using google and duckduckgo, and the phrase "By using
the CONTINUE option, the COPY command should" doesn't exist anywhere.

Which suggests that it wasn't "some tutorial" but rather hallucination
by chatgpt or some other "ai" that provides untruths.

In future, I would suggest to verify the things that these things spew,
as even 5 second glance at copy documentation
https://www.postgresql.org/docs/current/sql-copy.html shows that there
is no such option.

depesz