Re: generating UPDATE SET ... WHERE PK = ...

[Guillaume Lelarge <guillaume(at)lelarge(dot)info>]

Laurent ROCHE a écrit :
> 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) ?
> 

Why don't you use the UPDATE script from pgAdmin's table contextual menu ?

Regards.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com