On 23 Jan 2007 13:05:41 -0800, slawosz <[EMAIL PROTECTED]> wrote:
Hello,
I have to relpace string
http://example.com/index.php?module=articles&id= to string /module/ in
whole column in table. How exacly use replace? I noob in postgres, I
think it could be quite easy.
Please, help
try replace command for simple things:
Administrator=# select replace ('abcdef', 'ab', '12');
replace
---------
12cdef
(1 row)
(to do the whole table, do:)
update foo set bar = replace(bar, ab, '12');
for more complex things use regex_replace() (see docs)
merlin
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
