Re: COPY questions

Поиск
Список
Период
Сортировка
От Bill Todd
Тема Re: COPY questions
Дата
Msg-id 499C7216.3020606@dbginc.com
обсуждение исходный текст
Ответ на Re: COPY questions  (Adrian Klaver <aklaver@comcast.net>)
Ответы Re: COPY questions  (Tony Caduto <tony_caduto@amsoftwaredesign.com>)
Список pgsql-general
Adrian Klaver wrote:
On Wednesday 18 February 2009 10:56:45 am Bill Todd wrote: 
If the COPY command fails does it identify the offending row?

After reading the manual and the wiki I assume that there is no way to
tell copy to start with the Nth record in the input file. Is that
correct? It seems like such an obvious feature I was surprised not to
find it. Thanks.

Bill   
Take a look at:
http://pgfoundry.org/projects/pgloader/

It offers what you are looking for.
 
Thanks for the suggestion but pgloader appears to be a Linux only solution and my environment is Windows. The other problem is that there is no documentation that I could find (other than a PDF made from slides).

Bill

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

Предыдущее
От: Mike Christensen
Дата:
Сообщение: When adding millions of rows at once, getting out of disk space errors
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: When adding millions of rows at once, getting out of disk space errors