[SQL] ignoring primary key violations in COPY command

2007-05-19 Thread singh.srajendra
Hi all, We are importing the data from the CSV file into the database using COPY command. But when the 'primary key ' violation occurs , it stops Then and there and data is not updated into the tables. Also in the CSV file the number of columns is not fixed , its varies In number , it can ra

[SQL] ignoring primary key violations in COPY command

2007-05-19 Thread singh.srajendra
Hi all, We are importing the data from the CSV file into the database using COPY command. But when the 'primary key ' violation occurs , it stops Then and there and data is not updated into the tables. Also in the CSV file the number of columns is not fixed , its varies In number , it can range