Re: Syntax error in a large COPY - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: Syntax error in a large COPY
Date
Msg-id 20071107002944.GP8635@alvh.no-ip.org
Whole thread Raw
In response to Re: Syntax error in a large COPY  (Reg Me Please <regmeplease@gmail.com>)
Responses Re: Syntax error in a large COPY  (Reg Me Please <regmeplease@gmail.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: (Never?) Kill Postmaster?
Next
From: Gregory Stark
Date:
Subject: Re: Postgresql simple query performance question