generating UPDATE SET ... WHERE PK = ...

[Laurent ROCHE <laurent_roche(at)yahoo(dot)com>]

Hi,

I would like to generate with a request a SQL order like
UPDATE tab1
 SET col_a = ?, col_b = ? ...
WHERE pk = ?

for each table of a given schema (in fact what I want is slightly more complicated but if I can write the above, I will be able to get the rest).

Will anyone be kind enough to share a piece of code doing this (from pgAdmin may be) ?


Cheers,
L(at)u
The Computing Froggy

---

Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail