| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Laurent ROCHE <laurent_roche(at)yahoo(dot)com> |
| Cc: | pgadmin-support(at)postgresql(dot)org |
| Subject: | Re: generating UPDATE SET ... WHERE PK = ... |
| Date: | 2007-11-12 14:48:42 |
| Message-ID: | 473867CA.1010908@lelarge.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Dave Page | 2007-11-12 14:58:23 | Re: Not able to add or remove argument in Parameters tab, Function Properties |
| Previous Message | Guillaume Lelarge | 2007-11-12 14:47:05 | Re: Not able to add or remove argument in Parameters tab, Function Properties |