Re: error in copy table from file

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: "mzmaxmail(at)libero(dot)it" <mzmaxmail(at)libero(dot)it>
Cc: "pgsql-sql" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: error in copy table from file
Date: 2002-12-11 18:59:00
Message-ID: gm2fvuk830v2d3jmft1575fha32igrja2t@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Wed, 11 Dec 2002 18:40:48 +0100, "mzmaxmail(at)libero(dot)it"
<mzmaxmail(at)libero(dot)it> wrote:
>copy table from 'path/file' using delimiters ';'
>
>it returns the following:
>
>'RROR: copy: line 1, Bad float8 input format '-0.123
^
This belongs to the end of the error message. Finding it here at the
beginning of the line makes me think your file has DOS style end of
lines (CR/LF). Convert them to Unix style (LF only).

Servus
Manfred

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2002-12-11 23:55:35 multi-user and multi-level database access
Previous Message Tomasz Myrta 2002-12-11 18:36:35 Re: Getting the latest unique items