Re: Best import approach? Delimiters in strings - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Best import approach? Delimiters in strings
Date
Msg-id [email protected]
Whole thread Raw
In response to Best import approach? Delimiters in strings  (Andrew Taylor <[email protected]>)
List pgsql-general
On 02/16/2013 09:02 AM, Andrew Taylor wrote:
> Hi,
>
> A bulk import (script attached) is failing.
>
> Error message:
> psql:/home/andyt/projects/django-stringer/txc/stops_inport.txt:86:
> ERROR:  invalid input syntax for type double precision: "stop_lat"
>
> I think the reason may be a delimiters in strings such as "Golders
> Green, Golders Green, stop GW"
>
> 490015496GW,"Golders Green, Golders Green, stop GW",,51.57207,-0.19549
>
> What's a good way to handle this?

What is the command string you are using to import the data?

>
> Thanks,
>
>
> Andy
>
>
>


--
Adrian Klaver
[email protected]

pgsql-general by date:

Previous
From: Andrew Taylor
Date:
Subject: Best import approach? Delimiters in strings
Next
From: Bret Stern
Date:
Subject: Re: Best import approach? Delimiters in strings