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