CODEWITHSUNDEEP
postgresqlcsv
Greg Barnett
Greg Barnett

Reputation: 11

Postgres: copy errors when extra tab on tab delimited text file

I have the three statements below that all work until it hits a row with an extra tab at the end of the tab delimited text file that I am trying to import. Any way to tell Postgres to ignore extra tabs?

copy mara FROM 'c:/Postgres MME/AG00_MARA.txt' DELIMITER E'\t' NULL '' CSV HEADER;

copy mara FROM 'c:/Postgres MME/AG00_MARA.txt' DELIMITER E'\t' CSV HEADER;

copy mara FROM 'c:/Postgres MME/AG00_MARA.txt' WITH (FORMAT csv, DELIMITER E'\t', NULL '', HEADER);

Image of Notepad++ Where I see the extra tab at the end of the row

Upvotes: 1

Views: 579

Answers (1)

Jakub Kania
Jakub Kania

Reputation: 16487

Don't try to ignore it, just fix your data by removing all the trailing tabs with regex \t$. For example in Linux:

sed -i 's/\t$//g' AG00_MARA.txt

Upvotes: 1

Related Questions