I have a CSV (tab-delimited in fact) file with 7,590,051 lines, according to wc -l
, which I want to import using COPY FROM
. I removed the table's primary key, so it has no constraints.
I ran COPY customer FROM '.../customer.dsv' WITH DELIMITER E'\t' CSV HEADER;
and it reported 7,588,671 rows imported and no errors, so it's missing 1,379 rows (already discounting the header line).
Since PostgreSQL didn't report any errors, how do you suggest I troubleshoot which rows are missing (and why they are missing)?