From: | <paul(dot)malm(at)lfv(dot)se> |
---|---|
To: | <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | delimeters psql /CSV |
Date: | 2019-06-07 10:01:51 |
Message-ID: | 785199B14156764C8EB14EF96CEDC44EE041CA@xw-exch03.lfv.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi, I have a problem with psql and CSV.
C:\Users\an\bin>C:\Tmp\psql -h 10.211.43.22 -p 5432 -U postgres -d aatest -w -c "\copy public.""Bayern"" FROM 'C:\Users\an\test\Bayern.csv' WITH DELIMITER ';' CSV"
Error: extra data after expected last column
CONTEXT: COPY Bayern, row 1: "48.455555555555556;11.800833333333333;Anglberg/Amper;Industrial plant;722;220;220;2133;0;0;Undefined..."
I have a table (Bayern) with all columns in the right format. There is a column-value which has a '/' in the string (Anglberg/Amper). I think that '/' is taken for a delimeter, since when I replace / with 'white space' it works.
I use ';' as delimeter. I have UTF-8 encoding in the db. Is there a way around this or do I have to go through all csv files and change '/' to white space?
Kind regards,
Paul
From | Date | Subject | |
---|---|---|---|
Next Message | Adrien Nayrat | 2019-06-07 10:12:16 | Re: Snowball Stemming Greek support not included in Release 12 beta |
Previous Message | Kostis Michail | 2019-06-07 09:04:50 | Re: Snowball Stemming Greek support not included in Release 12 beta |