Re: how to update a column

On December 12, 2003 02:16 am, dbuechel(at)tiscali(dot)ch wrote:
> I want to update only one colomn ('cout') of a PostgreSQL table (table
> name: aretes; colomns: gid, long, vit, acces, cout). For each line of the
> table I calculate the 'cout' attribut with Python, then I want to update
> the 'cout'attribut of each line with the new value. I tried with the update
> function
> of the pg module, but it wasn't sucessfull.
>
> Can anyone give me some help or an example of an update command?

That's a pretty basic operation. Perhaps you can post some code that you are
having trouble with and we can help you debug it.

--
D'Arcy J.M. Cain <darcy(at){druid|vex}.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.