Postgres Pro
Downloads
Home   >   mailing lists

Re: Error on import - Mailing list pgsql-general

From Tom Lane
Subject Re: Error on import
Date
Msg-id 18826.1035512885@sss.pgh.pa.us
Whole thread Raw
In response to Error on import  ("John" <johnp@totcon.com>)
Responses Re: Error on import
List pgsql-general
Tree view 
"John" <johnp@totcon.com> writes:
> 'RROR:  copy: line 1, Bad float8 input format '-73.0456

I think you've got DOS-style newlines (\r\n) in your data file.
Get rid of the carriage return characters (\r) and you'll be set.

            regards, tom lane

pgsql-general by date:

Previous
From: dan radom
Date:
Subject: Re: Changing size of varchar field
Next
From: Sergey Mamvriysky
Date:
Subject: ...