. 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:
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;
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
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