Error on import
От | John |
---|---|
Тема | Error on import |
Дата | |
Msg-id | 000001c27bc0$75de10a0$0400a8c0@eclipse обсуждение исходный текст |
Ответы |
Re: Error on import
|
Список | 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 |
В списке pgsql-general по дате отправления: