Error on import

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 |

Responses

Browse pgsql-general by date

  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