From: 高升 <13325718563@189.cn>
To: pgsql-bugs@lists.postgresql.org
Subject: about psql copy ,we would like to seek help,Thanks.
Date: Thu, 14 Dec 2023 09:04:55 +0800
Message-ID: <000301da2e29$8d2a7e00$a77f7a00$@cn> (raw)
PSQL engineers, hello:
We encountered a problem during the process of importing data from a text
file to the PG database using psql's COPY command, and we would like to seek
help. The issue is that if there are any exceptional records in the file,
the program exits, but we want to skip those erroneous records and continue
with the rest of the import.
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.
COPY table_name FROM '/path/to/data/file.csv' (FORMAT csv, DELIMITER ',',
NULL '', CONTINUE);
However, when we actually tried this, an error occurred, and it seems that
the parameter is not recognized.
ERROR: option "continue" not recognized
My psql version : psql (PostgreSQL) 12.7
Could this be due to the version? Are there any other ways to handle this?
Thank you for your support.
Best Regards.
Gaosheng
2023-12-14 from China
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: pgsql-bugs@postgresql.org
Cc: 13325718563@189.cn, pgsql-bugs@lists.postgresql.org
Subject: Re: about psql copy ,we would like to seek help,Thanks.
In-Reply-To: <000301da2e29$8d2a7e00$a77f7a00$@cn>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox