Skip site navigation (1) Skip section navigation (2)

Re: COPY command and skipping errors

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: "Tomeh, Husam" <htomeh(at)firstam(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: COPY command and skipping errors
Date: 2005-09-22 21:14:07
Message-ID: 20050922211406.GF31459@surnet.cl (view raw or flat)
Thread:
Lists: 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)

In response to

pgsql-admin by date

Next:From: Peter DarleyDate: 2005-09-22 22:18:00
Subject: Encrypted Disks
Previous:From: Hannes DorbathDate: 2005-09-22 21:07:22
Subject: Re: Backing up several tables using pg_dump -t

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group