Re: Syntax error in a large COPY

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Syntax error in a large COPY
Дата
Msg-id 20071107002944.GP8635@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Syntax error in a large COPY  (Reg Me Please <regmeplease@gmail.com>)
Ответы Re: Syntax error in a large COPY
Список pgsql-general
Reg Me Please wrote:
> Il Tuesday 06 November 2007 22:13:15 hai scritto:

> > Split it in half, with the appropriate sql on each end so the data
> > still works, and see which half causes a problem.  Keep splitting the
> > one that causes a problem in half until you have a small one with the
> > problem still.
> >
> > I'm guessing the problem will become obvious then.
>
> That's the "branch and bound". Editing 29M+ lines file takes some time.
> But this is the way I'm going to go right now.

Huh, why not just use pgloader?

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: (Never?) Kill Postmaster?
Следующее
От: Gregory Stark
Дата:
Сообщение: Re: Postgresql simple query performance question