Postgres Pro
Downloads
Home   >   mailing lists

Re: using the "copy from" command - Mailing list pgsql-general

From Joe Conway
Subject Re: using the "copy from" command
Date
Msg-id 4043B366.80907@joeconway.com
Whole thread Raw
In response to using the "copy from" command  ("Knepper, Michelle" <mknepper@intellidot.net>)
Responses Re: using the "copy from" command
List pgsql-general
Tree view 
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?

Joe

pgsql-general by date:

Previous
From: "Knepper, Michelle"
Date:
Subject: using the "copy from" command
Next
From: Joe Conway
Date:
Subject: Re: using the "copy from" command