Re: Best import approach? Delimiters in strings - Mailing 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
adrian.klaver@gmail.com