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