Re: how to update a column - Mailing list pgsql-interfaces

From D'Arcy J.M. Cain
Subject Re: how to update a column
Date
Msg-id 200312120459.11582.darcy@druid.net
Whole thread Raw
In response to how to update a column  (dbuechel@tiscali.ch)
List pgsql-interfaces
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.


pgsql-interfaces by date:

Previous
From: dbuechel@tiscali.ch
Date:
Subject: how to update a column
Next
From: Bruce Momjian
Date:
Subject: Re: Possible bug in ECPGlib thread-safety (Postgres