Postgres Pro
Downloads
Home   >   mailing lists

Re: delimeters psql /CSV - Mailing list pgsql-general

From Ron
Subject Re: delimeters psql /CSV
Date
Msg-id ea3db701-8a21-a9b4-f400-f69f780e3900@gmail.com
Whole thread Raw
In response to delimeters psql /CSV  (<paul.malm@lfv.se>)
List pgsql-general
Tree view
On 6/7/19 5:01 AM, paul.malm@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 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?


What if you escape the slashes with backslashes?

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: Kyle Lee
Date:
Subject: RE: Copyright and bundling the installer
Next
From: Ict Security
Date:
Subject: Strange connection limit problem