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

Started by Laurent ROCHEover 18 years ago1 messagesgeneral
Jump to latest
#1Laurent ROCHE
laurent_roche@yahoo.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@u
The Computing Froggy

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