Re: COPY command and skipping errors - Mailing list pgsql-admin

From Alvaro Herrera
Subject Re: COPY command and skipping errors
Date
Msg-id 20050922211406.GF31459@surnet.cl
Whole thread Raw
In response to Re: COPY command and skipping errors  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
On Thu, Sep 22, 2005 at 04:41:57PM -0400, Bruce Momjian wrote:
> Tomeh, Husam wrote:
> >
> > Is there a way to skip errors during the run of the COPY command
> > (loading data from a file to a table) like what Oracle SQL*Loader has?
> > The reason I'm asking is that if the extract file from the mainframe has
> > an invalid character, the COPY terminates and doesn't continue loading
> > the rest of records.
>
> No, but it is on the TODO list:

Also, I think PGLoader can do this.  It's on pgfoundry.org.

--
Alvaro Herrera                         Architect, http://www.EnterpriseDB.com
"Tiene valor aquel que admite que es un cobarde" (Fernandel)

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: COPY command and skipping errors
Next
From: Hannes Dorbath
Date:
Subject: Re: Backing up several tables using pg_dump -t