Please help - tks

Hi Folks

We have about 300,000 records to update, I have
created a file with the ids of the records to be
updated, since the number of records to be updated is
very large, the update statement takes forever and
server slows down dramatically, therefore I want to do
one at a time.

Do you guys have any script which may update records
one by one using the file that lists these records. I
am running postgresql sever under Unix, any kind of
script would do, whether its a perl, bash or sql
whatever script

Thanks for your help
Mike

http://briefcase.yahoo.com.au - Yahoo! Briefcase
- Manage your files online.