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

The first value seems more suspect, should be "490015496GW". Mixing
numeric and string values is best enclosed in quotes.


"Golders Green, Golders Green, stop GW" is normal if you want the
entire string between the quotes to arrive in a single column (with
the comma).




On Sat, 2013-02-16 at 17:02 +0000, 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?
>
>
> Thanks,
>
>
> Andy