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
