From: | "Knepper, Michelle" <mknepper(at)intellidot(dot)net> |
---|---|
To: | "Joe Conway" <mail(at)joeconway(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: using the "copy from" command |
Date: | 2004-03-02 18:11:58 |
Message-ID: | 57E2A340D65EB240B071FEED12F4777B0794DC@merlin.intellidot.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Joe!
I converted the text file to Unix, using EditPadPro, to get
rid of all the Windows characters. Got rid of any \r and end-of-line
stuff.
And the copy command worked beautifully. It entered all of the data
into the table.
Simple thing to do, but new to me.
Ciao. ;-)
-----Original Message-----
From: Joe Conway [mailto:mail(at)joeconway(dot)com]
Sent: Monday, March 01, 2004 2:28 PM
To: Knepper, Michelle
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] using the "copy from" command
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2004-03-02 18:45:21 | Re: [GENERAL] select statement against pg_stats returns |
Previous Message | scrappy | 2004-03-02 18:00:40 | stacy |