| 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: | Whole Thread | Raw Message | 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 |