Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: generating UPDATE SET ... WHERE PK = ...
- 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: Mon, 12 Nov 2007 15:48:42 +0100
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
- Prev by Date: Re: Not able to add or remove argument in Parameters tab, Function Properties
- Next by Date: Re: Not able to add or remove argument in Parameters tab, Function Properties
- Previous by thread: Re: Not able to add or remove argument in Parameters tab, Function Properties
- Next by thread: character number
- Indexes: