Problem importing CONCEPT.csv into Postgres

[Sanjay_Udoshi]

Error copying dataset on remote server

ERROR: extra data after last expected column

Where: COPY concept_synonym, line 104000: "41995111,“בני עי"ש”,4180047

41995115,“אשדוד”,4180047

41995117,“باقة-جت”,4181374

41…"

ERROR: extra data after last expected column

Where: COPY concept_synonym, line 104000: "41995111,“בני עי"ש”,4180047

41995115,“אשדוד”,4180047

41995117,“باقة-جت”,4181374

41…"

Any ideas as to why this is happening?

[Christian_Reich]

Looks like it chokes on the " in the Hebrew town name. You need to make sure the parameters for the quoting is set correctly.

[Sanjay_Udoshi]

Why are those " even there?

[Christian_Reich]

Ask the Israelis.

[Sanjay_Udoshi]

[nadavrap]

In Hebrew, acronyms are marked with double quotes sign before the last letter of the acronym