Re: Please help - tks

A quick and dirty solution would be something like (untested):

while read line; do
psql dbname -c "update table ... use 'line' as your id and data"
sleep 5
done < filename

where "filename" is the file with the ids in it. "dbname" is the name of your DB (of course!)

I am not sure what your file looks like, but you can do something like this. It could be easy, or harder, depending on what your file has.

adjust the sleep to your own specs.

--brett

P.S.

You could test this out by doing:

while read line; do
psql dbname -c "select * from table where id=$line"
sleep 5
done < filename

On Thu, 18 Oct 2001 16:35:01 +1000 (EST)
Mr OCP <mr_ocp(at)yahoo(dot)com> wrote:

> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html

_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com