ignoring primary key violations in COPY command - Mailing list pgsql-sql

<p align="LEFT"><span lang="en-us"><font face="Tahoma" size="2">Hi all, </font></span><p align="LEFT"><span
lang="en-us"><fontface="Tahoma" size="2">We are importing the data from the CSV file into the database using COPY
command.</font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Tahoma" size="2">But when
the</font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Tahoma" size="2">‘</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Tahoma" size="2">primary key</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Tahoma" size="2">‘</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Tahoma" size="2"> violation occurs , it stops </font></span><p align="LEFT"><span
lang="en-us"><fontface="Tahoma" size="2">Then and there and data is not</font></span><span lang="en-us"></span><span
lang="en-us"><font face="Tahoma" size="2">updated</font></span><span lang="en-us"></span><span lang="en-us"><font
face="Tahoma"size="2"> into the</font></span><span lang="en-us"></span><span lang="en-us"> <font face="Tahoma"
size="2">tables.</font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Tahoma" size="2">Also
i</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Tahoma" size="2">n the CSV file the number of
columnsis not fixed , its varie</font></span><span lang="en-us"></span><span lang="en-us"><font face="Tahoma"
size="2">s</font></span><spanlang="en-us"></span><span lang="en-us"><font face="Tahoma" size="2"> </font></span><p
align="LEFT"><spanlang="en-us"><font face="Tahoma" size="2">In n</font></span><span lang="en-us"></span><span
lang="en-us"><fontface="Tahoma" size="2">umber , it can range anywhere between 1 -22,</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Tahoma" size="2">I need to figure out a way such that I need
to</font></span><spanlang="en-us"></span><span lang="en-us"> <font face="Tahoma" size="2">update</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Tahoma" size="2"> only thos</font></span><span
lang="en-us"></span><spanlang="en-us"><font face="Tahoma" size="2">e columns which are present </font></span><p
align="LEFT"><spanlang="en-us"><font face="Tahoma" size="2">In the CSV file . This of course</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Tahoma" size="2"></font></span><span lang="en-us"></span><span
lang="en-us"><font face="Tahoma" size="2">I would like to</font></span><span lang="en-us"></span><span lang="en-us">
<fontface="Tahoma" size="2">accomplish</font></span><span lang="en-us"></span><span lang="en-us"><font face="Tahoma"
size="2">using COPY command , Please let me know if at all this is possible in postgresql</font></span><span
lang="en-us"></span><spanlang="en-us"> <font face="Tahoma" size="2">8.1</font></span><p align="LEFT"><i><span
lang="en-us"></span></i><aname=""><i><span lang="en-us">Thanks and regards,</span></i></a><span
lang="en-us"></span><spanlang="en-us"></span><p align="LEFT"><span lang="en-us"><font color="#008000" size="2">Rajendra
Singh</font></span><palign="LEFT"><span lang="en-us"> </span><p align="LEFT"><span lang="en-us"><font color="#FF0000"
size="2">WiproTechnologies</font></span><span lang="en-us"></span><span lang="en-us"></span><p align="LEFT"><span
lang="en-us"><fontcolor="#000080" size="2">Plot No. 72, Hosur Main road</font></span><span lang="en-us"></span><span
lang="en-us"></span><palign="LEFT"><span lang="en-us"><font color="#000080" size="2">Keonics Electronics
City</font></span><spanlang="en-us"></span><span lang="en-us"></span><p align="LEFT"><span lang="en-us"><font
color="#000080"size="2">Bangalore- 560100, INDIA</font></span><span lang="en-us"></span><span lang="en-us"></span><p
align="LEFT"><i><spanlang="en-us"><font color="#3366FF">I believe we should all pay our tax with a smile. I tried - but
theywanted cash</font></span></i><span lang="en-us"><b></b></span><b><span lang="en-us"></span></b><p
align="LEFT"><spanlang="en-us"></span><table><tr><td bgcolor="#ffffff"><font color="#000000"><br /> The information
containedin this electronic message and any attachments to this message are intended for the exclusive use of the
addressee(s)and may contain proprietary, confidential or privileged information. If you are not the intended recipient,
youshould not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies
ofthis message and any attachments. <br /><br /> WARNING: Computer viruses can be transmitted via email. The recipient
shouldcheck this email and any attachments for the presence of viruses. The company accepts no liability for any damage
causedby any virus transmitted by this email.<br /><br /> www.wipro.com<br /></font></td></tr></table>