Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Taylor
Subject Best import approach? Delimiters in strings
Date
Msg-id CAFAE3Jw+e4hMa00ip2365omagMP7RtEErC=mLz1jkLX6YmOLQQ@mail.gmail.com
Whole thread Raw
Responses Re: Best import approach? Delimiters in strings  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: Best import approach? Delimiters in strings  (Bret Stern <bret_stern@machinemanagement.com>)
Re: Best import approach? Delimiters in strings  (Andrew Taylor <andydtaylor@gmail.com>)
List pgsql-general
Tree view
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
Attachment

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Visual query builder for PosgreSQL?
Next
From: Adrian Klaver
Date:
Subject: Re: Best import approach? Delimiters in strings