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
adrian.klaver@gmail.com