Re: using the "copy from" command

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Knepper, Michelle" <mknepper(at)intellidot(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: using the "copy from" command
Date: 2004-03-01 22:28:15
Message-ID: 4043B8FF.7070609@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Joe Conway wrote:
> Knepper, Michelle wrote:
>> medispan=# copy mmw_ade_com from
>> '/home/mknepper/medispan/datafiles/mmwadecom.txt' with delimiter '|';
>> ": can't parse "ne 1, pg_atoi: error in "14608
>
> Looks like bad data in line 14608. What does that line of your input
> file look like?

Strike that -- it actually is a problem in line 1, isn't it (you cut off
the line number in the error message above)? It might be end-of-line
character problem. Was your input file created or edited on Windows by
chance (i.e. ends in \r\n instead of \n)?

Joe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nick Barr 2004-03-01 22:48:26 Linux Labs
Previous Message Joe Conway 2004-03-01 22:04:22 Re: using the "copy from" command