View Single Post

   
  #1 (permalink)  
Old 04-17-2008, 08:13 PM
Laurent ROCHE
 
Posts: n/a
Default generating UPDATE SET ... WHERE PK = ...

Hi,

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

for each table of a given schema (in fact what I want is slightly more complicated butif 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
Reply With Quote