POSTGRES import CSV

mcemberci's profile image mcemberci posted 9 years ago in General Permalink
Now I am trying to import a csv file into postgres table but give errors and log output shows
INSERT LOW_PRIORITY IGNORE INTO "public"."beyaz_liste" ("sira", "modelyili", "birim", "markamodel", "plaka")
VALUES ('82', '2014', 'İD.MALİ İŞ.DAİ.BŞK.', 'TOYOTA COROLLA', '55AH619');
syntax error near LOW_PRIORITY etc....

if I remove LOW_PRIORITY IGNORE then succesfully insert one line manually.
mcemberci's profile image mcemberci posted 9 years ago Permalink
No response ?
ansgar's profile image ansgar posted 9 years ago Permalink
What if you uncheck "Low priority" in the import dialog?
mcemberci's profile image mcemberci posted 9 years ago Permalink
Thanks, I have thought when I import to postgres heidisql automatically switches off related commands.
ansgar's profile image ansgar posted 9 years ago Permalink
Right - just done so in r4977. See this thread for details.

Please login to leave a reply, or register at first.