Thread: how to update a column

how to update a column

From
dbuechel@tiscali.ch
Date:
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








Re: how to update a column

From
"D'Arcy J.M. Cain"
Date:
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.