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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
