From: Manfred Koizar <mkoi-pg@aon.at>
To: mzmaxmail@libero.it <mzmaxmail@libero.it>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: error in copy table from file
Date: Wed, 11 Dec 2002 19:59:00 +0100
Message-ID: <gm2fvuk830v2d3jmft1575fha32igrja2t@4ax.com> (raw)
In-Reply-To: <H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it>
References: <H6YUG0$F8E94BAAD19150F488C52E174AF2FFB7@libero.it>
On Wed, 11 Dec 2002 18:40:48 +0100, "mzmaxmail@libero.it"
<mzmaxmail@libero.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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mkoi-pg@aon.at, mzmaxmail@libero.it
Subject: Re: error in copy table from file
In-Reply-To: <gm2fvuk830v2d3jmft1575fha32igrja2t@4ax.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox