Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 714B09F9D9A for ; Mon, 27 Aug 2007 05:18:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21037-05 for ; Mon, 27 Aug 2007 05:18:33 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web58108.mail.re3.yahoo.com (web58108.mail.re3.yahoo.com [68.142.236.131]) by postgresql.org (Postfix) with SMTP id F2D199F9DD5 for ; Mon, 27 Aug 2007 05:18:36 -0300 (ADT) Received: (qmail 48430 invoked by uid 60001); 27 Aug 2007 08:18:36 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Zsx1x+BjRJXxE933Jrs5EJ5+ke6aq1NW4G1B4BC4QCY91SXyTcUxIE4eb1DrscUmn+J5CR08YhTrXx743PFwXINVmllXYsNKXI8H5NkmTKsvB0RimKXdrHnKmCP5+O8ZU0bz/xLaNz3qNlzI0ngPXphOwtpVYNvMsgrUXJe7Iok=; X-YMail-OSG: U5z6lCwVM1m4J9pvRWxiLLpsFIPOWFeBsYZkQrF9M3m49x_PLzqqzrCtc0S_EWVNUFKnZ9bSqQ0bHB3.V6kPG88lElHTVLCr90BDsU3H.aCiR3y1iILG9j2JcvGhEg-- Received: from [219.142.118.227] by web58108.mail.re3.yahoo.com via HTTP; Mon, 27 Aug 2007 16:18:35 CST Date: Mon, 27 Aug 2007 16:18:35 +0800 (CST) From: Reply-To: qinghuamail-postgresqlfans@yahoo.com Subject: Copy cmd error To: postgresql-admin MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-579661364-1188202715=:48089" Content-Transfer-Encoding: 8bit Message-ID: <972942.48089.qm@web58108.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.001 tagged_above=0 required=5 tests=BAYES_60=1, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200708/323 X-Sequence-Number: 26654 --0-579661364-1188202715=:48089 Content-Type: text/plain; charset=gb2312 Content-Transfer-Encoding: 8bit hi,all I use COPY cmd to import large data to database,but I have a question, when occured the first error, It always stopped, I need it to be continue,and reject the error rows to a file, how to do this? thanks! --------------------------------- 雅虎邮箱,以安全著称,是值得信赖的邮箱专家! --0-579661364-1188202715=:48089 Content-Type: text/html; charset=gb2312 Content-Transfer-Encoding: 8bit hi,all

I use COPY cmd to import large data to database,but I have a question,

when occured the first error, It always stopped, I need it to be continue,and reject the error rows to a file, how to do this?

thanks!



雅虎邮箱,以安全著称,是值得信赖的邮箱专家! --0-579661364-1188202715=:48089--