Please help - tks - Mailing list pgsql-admin

From Mr OCP
Subject Please help - tks
Date
Msg-id 20011018063501.31635.qmail@web20610.mail.yahoo.com
Whole thread Raw
Responses Re: Please help - tks  (Brett Schwarz <brett_schwarz@yahoo.com>)
Re: Please help - tks  (Joel Burton <joel@joelburton.com>)
Re: Please help - tks  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
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.

pgsql-admin by date:

Previous
From: "postgresql"
Date:
Subject: Re: PgAccess on OS X--was "tcl wish--simple configure
Next
From: Francisco Solari
Date:
Subject: "Can't Find any tables, sequences or indexes!" Message