Programmiererforum

COPY PUBLIC.TEST_TABLE(
TEST
)
FROM STDIN
WITH (
FORMAT CSV,
ON_ERROR IGNORE,
LOG_VERBOSITY VERBOSE

skipping row due to data type incompatibility at line 1 for column "TEST": "'1abcdefg'
1 rows were skipped due to data type incompatibility

from psycopg2 import connect
conn = connect(**conn_config)
curs = conn.cursor()
sql = """COPY PUBLIC.TEST_TABLE(
TEST
)
FROM STDIN
WITH (
FORMAT CSV,
ON_ERROR IGNORE,
LOG_VERBOSITY VERBOSE
)"""
curs.copy_expert(sql, csv)
conn.commit()

Als Datenbank wird die Postgresql 17-Version verwendet.
Ich verwende Parameter in der Kopieranforderung: ON_ERROR, LOG_VERBOSITY
[code]COPY PUBLIC.TEST_TABLE(
TEST
)
FROM STDIN
WITH (
FORMAT CSV,
ON_ERROR IGNORE,
LOG_VERBOSITY VERBOSE
[/code]
Wenn die Zeilen abgelehnt werden, erhalte ich dieses Protokoll.
Beispiel:
[code]skipping row due to data type incompatibility at line 1 for column "TEST": "'1abcdefg'
1 rows were skipped due to data type incompatibility
[/code]
Wie erhalte ich dieses Protokoll, wenn ich Python psycopg2 aufrufe?
[code]from psycopg2 import connect
conn = connect(**conn_config)
curs = conn.cursor()
sql = """COPY PUBLIC.TEST_TABLE(
TEST
)
FROM STDIN
WITH (
FORMAT CSV,
ON_ERROR IGNORE,
LOG_VERBOSITY VERBOSE
)"""
curs.copy_expert(sql, csv)
conn.commit()
[/code]