| From: | Andrew Taylor <andydtaylor(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Best import approach? Delimiters in strings |
| Date: | 2013-02-16 17:02:29 |
| Message-ID: | CAFAE3Jw+e4hMa00ip2365omagMP7RtEErC=mLz1jkLX6YmOLQQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 | Content-Type | Size |
|---|---|---|
| stops_inport.txt | text/plain | 4.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2013-02-16 17:22:31 | Re: Best import approach? Delimiters in strings |
| Previous Message | Thomas Kellerer | 2013-02-16 16:17:50 | Re: Visual query builder for PosgreSQL? |