Thread: how to update a column

Hello,

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?

Thanks
Daniela

On December 12, 2003 02:16 am, dbuechel@tiscali.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@{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.