Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id E394E9FB3DF for ; Thu, 17 May 2007 00:23:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 47026-07 for ; Thu, 17 May 2007 00:23:50 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web33309.mail.mud.yahoo.com (web33309.mail.mud.yahoo.com [68.142.206.124]) by postgresql.org (Postfix) with SMTP id 321379FB3B7 for ; Thu, 17 May 2007 00:23:50 -0300 (ADT) Received: (qmail 66233 invoked by uid 60001); 17 May 2007 03:23:49 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=uJBfRipRE9I1OQ5lj0c5Pbu/skdTWehX0PTTAvv2+TLfjJ1uziLibIBYBzUYWoW3qnsNbBtx3EaniIVW1mFgP61Y7lJrd+LSTLPHKZli+lHt35r+z3Kz5ZQ1sXPHcSuJWKzIQXwrcp5iRII2D0eEnkOT1iGsQTKbvEPsu7iwDWE=; X-YMail-OSG: 8hyLggoVM1kDU22_JUavB3yXQq40sKc76GOIHcRHqlp2J_zaOkjwr8hp8IwUelfXeQQ4R5VZ54w.oKfJeJZq5i2Z2nLiLj4vuM0ns7c_Wpmz0D0_3fOXvMaBaN18kA-- Received: from [68.142.201.143] by web33309.mail.mud.yahoo.com via HTTP; Wed, 16 May 2007 20:23:49 PDT X-Mailer: YahooMailRC/651.23 YahooMailWebService/0.7.41.10 Date: Wed, 16 May 2007 20:23:49 -0700 (PDT) From: Sandeep Khandelwal Subject: Re: COPY command with bad input To: pgsql-interfaces@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Message-ID: <188521.66061.qm@web33309.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.258 tagged_above=0 required=5 tests=AWL=-0.789, BAYES_00=-2.599, DNS_FROM_RFC_ABUSE=0.2, DNS_FROM_RFC_POST=1.708, DNS_FROM_RFC_WHOIS=1.447, FROM_HAS_ULINE_NUMS=0.291 X-Spam-Level: X-Archive-Number: 200705/33 X-Sequence-Number: 6540 Hi All.=0A=0APlease help me.=0A=0AThanks, =0ASandeep=0A=0A=0A----- Original= Message ----=0AFrom: Sandeep Khandelwal = =0ATo: pgsql-interfaces@postgresql.org=0ASent: Tuesday, May 15, 2007 2:41:0= 0 PM=0ASubject: COPY command with bad input=0A=0A=0AHi All.=0A=0AI am tryin= g to load data from a text file to Postgres table using COPY command. If te= xt file has some invalid rows then COPY command stops at the first error. = =0A=0AAs you can see, MySQL =93load data infile=94 has IGNORE option. If y= ou specify IGNORE, input rows that duplicate an existing row on a unique ke= y value are skipped. Do we have similar option for Postgres COPY command ?= =0A=0APlease help me.=0A=0AThanks,=0ASandeep=0A=0A=0A=0A=0A________________= ____________________________________________________________________=0ANeed= Mail bonding?=0AGo to the Yahoo! Mail Q&A for great tips from Yahoo! Answe= rs users.=0Ahttp://answers.yahoo.com/dir/?link=3Dlist&sid=3D396546091=0A=0A= =0A =0A______________________________________________________________= ______________________Got a little couch potato? =0ACheck out fun summer ac= tivities for kids.=0Ahttp://search.yahoo.com/search?fr=3Doni_on_mail&p=3Dsu= mmer+activities+for+kids&cs=3Dbz