Unfortunately my starting point is data in the format of that example line. I hasn't spotted the lack of quotes on the first value. Given this format, is my best bet to write a script transforming it pre-import to postgres? I.e. are there no arguments I could pass to the import process to handle this directly? Thanks
On 16 Feb 2013 17:02, "Andrew Taylor" <andydtaylor@xxxxxxxxx> 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.19549What's a good way to handle this?Thanks,
Andy
