[GENERAL] update table from a csv file

2012-12-27 Thread Kirk Wythers
I have been using COPY FROM to do a mass import of records from CSV files into a new database. I have discover however, a small number of records ( a few thousand) in one of the files that contain new data that needs to be added to the database, but on rows that have a primary key and have

Re: [GENERAL] update table from a csv file

2012-12-27 Thread Adrian Klaver
On 12/27/2012 08:27 AM, Kirk Wythers wrote: I have been using COPY FROM to do a mass import of records from CSV files into a new database. I have discover however, a small number of records ( a few thousand) in one of the files that contain new data that needs to be added to the database, but

Re: [GENERAL] update table from a csv file

2012-12-27 Thread Kirk Wythers
On Dec 27, 2012, at 10:39 AM, Adrian Klaver adrian.kla...@gmail.com wrote: No. Some questions though. Thanks for the reply Adrian. What version pf Postgres? 9.1 Is that the actual UPDATE statement, I see no SET? I was reading the docs but obviously don't understand the syntax of the

Re: [GENERAL] update table from a csv file

2012-12-27 Thread Adrian Klaver
On 12/27/2012 08:50 AM, Kirk Wythers wrote: On Dec 27, 2012, at 10:39 AM, Adrian Klaver adrian.kla...@gmail.com mailto:adrian.kla...@gmail.com wrote: No. Some questions though. Thanks for the reply Adrian. What version pf Postgres? 9.1 Is that the actual UPDATE statement, I see no