SEO

#1 (**permalink**) 04-17-2008, 08:13 PM

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

#2 (**permalink**) 04-17-2008, 08:13 PM

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

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