Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id A1F539FB524 for ; Tue, 15 May 2007 06:11:10 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 70486-02 for ; Tue, 15 May 2007 06:11:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from web33313.mail.mud.yahoo.com (web33313.mail.mud.yahoo.com [68.142.206.128]) by postgresql.org (Postfix) with SMTP id 331E79FB550 for ; Tue, 15 May 2007 06:11:05 -0300 (ADT) Received: (qmail 68885 invoked by uid 60001); 15 May 2007 09:11:00 -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=U1X0dJxJnCEQa+RRWq401GrIi5iPHINaLtcBUeCEpuOYPaOITdaHO3NybYTHQUuYQS4U3ug+3VD4QZzXgROQ7bTGBC7qIOzByRGGiMKFAwMIaOhZBFgKml4JFMw4LwFrPr56k0bVm2wJGtA+lgijbxh2VN/cbKKSuS/FfkEP7VY=; X-YMail-OSG: SLyJKTEVM1mcGpbFnZ7tMfXwOIZB7cMXOq8Pm6B6z6yPy4m.99zC9hg5pgAeYmbVz5uTWVEcOd1Ff5QpzDDv7oK2mrXt2jUFBUP0V1Cn7YxsByN8zEmyoFzAvf02qw-- Received: from [68.142.201.143] by web33313.mail.mud.yahoo.com via HTTP; Tue, 15 May 2007 02:11:00 PDT X-Mailer: YahooMailRC/651.23 YahooMailWebService/0.7.41.10 Date: Tue, 15 May 2007 02:11:00 -0700 (PDT) From: Sandeep Khandelwal Subject: 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: <126544.67764.qm@web33313.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.047 tagged_above=0 required=5 tests=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/29 X-Sequence-Number: 6536 Hi All.=0A=0AI am trying to load data from a text file to Postgres table us= ing COPY command. If text file has some invalid rows then COPY command stop= s at the first error. =0A=0AAs you can see, MySQL =93load data infile=94 ha= s IGNORE option. If you specify IGNORE, input rows that duplicate an exist= ing row on a unique key value are skipped. Do we have similar option for Po= stgres 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! Answers users.=0Ahttp://answers.yahoo.com/dir/?link=3Dlis= t&sid=3D396546091