X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 083FFD7F14 for ; Thu, 22 Sep 2005 18:13:58 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 14487-10 for ; Thu, 22 Sep 2005 21:13:53 +0000 (GMT) Received: from mx1.surnet.cl (mx2.surnet.cl [216.155.73.181]) by svr1.postgresql.org (Postfix) with ESMTP id 68F7ED7B09 for ; Thu, 22 Sep 2005 18:13:54 -0300 (ADT) Received: from unknown (HELO cluster.surnet.cl) ([216.155.73.165]) by mx1.surnet.cl with ESMTP; 22 Sep 2005 17:13:36 -0400 X-IronPort-AV: i="3.97,114,1125892800"; d="scan'208"; a="11447085:sNHT84662662" Received: from alvh.no-ip.org (216.155.84.209) by cluster.surnet.cl (7.0.043) (authenticated as alvherre@surnet.cl) id 4327E85F000F09DE; Thu, 22 Sep 2005 17:13:55 -0400 Received: by alvh.no-ip.org (Postfix, from userid 1000) id 32B89C37444; Thu, 22 Sep 2005 17:14:07 -0400 (CLT) Date: Thu, 22 Sep 2005 17:14:07 -0400 From: Alvaro Herrera To: Bruce Momjian Cc: "Tomeh, Husam" , pgsql-admin@postgresql.org Subject: Re: COPY command and skipping errors Message-ID: <20050922211406.GF31459@surnet.cl> Mail-Followup-To: Bruce Momjian , "Tomeh, Husam" , pgsql-admin@postgresql.org References: <200509222041.j8MKfvj03938@candle.pha.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200509222041.j8MKfvj03938@candle.pha.pa.us> User-Agent: Mutt/1.5.10i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=2.392 required=5 tests=[AWL=-0.434, DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, FORGED_RCVD_HELO=0.05, RCVD_IN_NJABL_PROXY=1.026] X-Spam-Level: ** X-Archive-Number: 200509/241 X-Sequence-Number: 18978 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)