Re: using the "copy from" command

Поиск
Список
Период
Сортировка
От Joe Conway
Тема Re: using the "copy from" command
Дата
Msg-id 4043B8FF.7070609@joeconway.com
обсуждение исходный текст
Ответ на Re: using the "copy from" command  (Joe Conway <mail@joeconway.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: using the "copy from" command
Следующее
От: Nick Barr
Дата:
Сообщение: Linux Labs