Re: delimeters psql /CSV

Ron <ronljohnsonjr@xxxxxxxxx> · Fri, 7 Jun 2019 06:24:45 -0500



    On 6/7/19 5:01 AM, paul.malm@xxxxxx 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.