Received: from postgresql.org.org (webmail.postgresql.org [216.126.85.28]) by postgresql.org (8.11.3/8.11.1) with SMTP id f3ANlR896625 for ; Tue, 10 Apr 2001 19:47:27 -0400 (EDT) (envelope-from pgsql-sql-owner@postgresql.org) Received: from edison.gits.net.th (edison.gits.net.th [164.115.2.130]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3A88R865440; Tue, 10 Apr 2001 04:08:27 -0400 (EDT) (envelope-from jaruwan@gits.net.th) Received: from wan ([203.150.154.109]) by edison.gits.net.th (8.10.1/8.10.1) with SMTP id f3A88eI20707; Tue, 10 Apr 2001 15:08:40 +0700 (GMT) Message-ID: <001f01c0c196$46bcb000$6d9a96cb@ntl> From: "Jaruwan Laongmal" To: , Subject: problem with copy command Date: Tue, 10 Apr 2001 15:14:32 +0700 MIME-Version: 1.0 Content-Type: text/plain; charset="windows-874" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200104/149 X-Sequence-Number: 2497 dear all, I currently using postgresql v7.0.3 when i import text file to table with command "copy tablename from '/tmp/a.txt'; and it shows "copy: line 20, Cannot insert a duplicate key into unique index testpri_pk" ,then it exits with doing nothing. I want to ignore this errors and continue copy the next record. How to do that? if I don't filter in '/tmp/a.txt' before using copy command. Thank you so much for your help in advance . Regards Jaruwan