Postgres Pro
Downloads
Home   >   mailing lists

Re: generating UPDATE SET ... WHERE PK = ... - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: generating UPDATE SET ... WHERE PK = ...
Date
Msg-id 473867CA.1010908@lelarge.info
Whole thread Raw
In response to generating UPDATE SET ... WHERE PK = ...  (Laurent ROCHE <laurent_roche@yahoo.com>)
List pgadmin-support
Tree view 
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.orghttp://dalibo.com

pgadmin-support by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties
Next
From: Dave Page
Date:
Subject: Re: Not able to add or remove argument in Parameters tab, Function Properties