From: | "John" <johnp(at)totcon(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Error on import |
Date: | 2002-10-25 00:50:05 |
Message-ID: | 000001c27bc0$75de10a0$0400a8c0@eclipse |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I am attempting to import a zip code database into a postgresql using
COPY.. but I am getting an error that the data type of the for longitude
doesn't match the table's data type (double precision)
'RROR: copy: line 1, Bad float8 input format '-73.0456
Any help on why -73.0456 won't go in is appreciated. Thanks!
Sample line:
0501,HOLTSVILLE,SUFFOLK,NY,NEW
YORK,D,U,36103,516,EASTERN,40.8154,-73.0456
and the table definition:
Column | Type | Modifiers
-------------+-----------------------+-----------
zipcode | character(5) |
city | character varying(28) |
county | character varying(25) |
statecode | character(2) |
statename | character varying(75) |
citytype | character(1) |
zipcodetype | character(1) |
countyfips | character(5) |
areacode | character(3) |
timezone | character varying(15) |
latitude | double precision |
longitude | double precision |
From | Date | Subject | |
---|---|---|---|
Next Message | dan radom | 2002-10-25 01:10:01 | Re: Changing size of varchar field |
Previous Message | Thomas Lockhart | 2002-10-25 00:27:29 | Re: Date weirdness |