trying to update a large table

[keak]

Hi there,
I have a large table (around 40,000 entries) and I am trying to update a every row via a vb asp script by access it via the browser. I've tried to set the timeout to something high, but it still hangs my system.

When I use pgadmin3 (SQL statement) it works but then I need to do a slight programming.
I basically need to take the id field in this table and append the string '_user' to that id and update the 'login' field with that value.

Can someone suggest the best approach for this? Is this even possible from the postgres command line?

 

[feherke]

Hi

I would ask this question in a VB or ASP forum. Somewhere there could be the setting for the timeout. Or maybe in your web server's configuration.

I definitely would do such operations in the PostgreSQL interactive terminal ( [tt]psql[/tt] ). If is a repetitive task, then I would put the command(s) in a file, but still execute with [tt]psql[/tt].

Feherke.

http://rootshell.be/~feherke/