SV: delimeters psql /CSV

2019-06-07 Thread paul.malm
. Then it works! Could it have something to do with encoding. I have no idea. Kind regards, Paul -Ursprungligt meddelande- Från: Daniel Verite [mailto:dan...@manitou-mail.org] Skickat: den 7 juni 2019 14:03 Till: Malm, Paul (Operations AIM) Kopia: pgsql-general@lists.postgresql.org Ämne: Re:

Re: delimeters psql /CSV

2019-06-07 Thread Daniel Verite
Paul Malm wrote: > 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.456;

Re: delimeters psql /CSV

2019-06-07 Thread Ron
On 6/7/19 5:01 AM, paul.m...@lfv.se wrote: 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 col

delimeters psql /CSV

2019-06-07 Thread paul.malm
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.4