> In my opinion your best bet in terms of getting around the primary
> key
> violation is to create a temporary table ...
good idea! from my experience it's almost always best to pull raw info
into a buffer table before introducing it into the real world.
___
[EMAIL PROTECTED] wrote:
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 var
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
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
