Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id DB3039F9DA0 for ; Mon, 27 Aug 2007 05:17:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 54354-09 for ; Mon, 27 Aug 2007 05:17:06 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web58111.mail.re3.yahoo.com (web58111.mail.re3.yahoo.com [68.142.236.134]) by postgresql.org (Postfix) with SMTP id 9D8EF9F9D9A for ; Mon, 27 Aug 2007 05:17:08 -0300 (ADT) Received: (qmail 22923 invoked by uid 60001); 27 Aug 2007 08:17:07 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=Uo5JsnR+DN0tgeOWfhh8kKCO1pZ2EUgmVpxAOPtd0veySyeig4JJtCPOBgQ0zkPUGp3uHV9QmPt89VXx5jW+qc6RWMuaBkrBUUiUCFwUgGcqy9iR0uUuf4oBPpxj/qNPMYDIvYUpIr/4mWS7QCHscJ1FcTxf+d8Fysjs/MDpoqA=; X-YMail-OSG: VJFyGo8VM1k_pSsBnQ98RAaYMU1qxp28N7coufFtNTyYE4yqVICefU5N7MpjnI.DwEe25pY_mUEi7At3S2if8C96JgZQJlEByqu8mMdDHom9xDTm..4XrZoQkCLzIQ-- Received: from [219.142.118.227] by web58111.mail.re3.yahoo.com via HTTP; Mon, 27 Aug 2007 16:17:07 CST Date: Mon, 27 Aug 2007 16:17:07 +0800 (CST) From: feng xinguo Subject: use copy command! To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1664419667-1188202627=:22426" Content-Transfer-Encoding: 8bit Message-ID: <590927.22426.qm@web58111.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/329 X-Sequence-Number: 26660 --0-1664419667-1188202627=:22426 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-1664419667-1188202627=:22426 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-1664419667-1188202627=:22426--