I looked around for a definitive answer to this question but to no avail. It appears that PostgreSQL does not implement the SQL function REPLACE() , which, in MySQL works like this:
REPLACE(str,from_str,to_str)
Returns the string str with all all occurrences of the string from_str replaced by the string to_str:
What do folks usually do when they have to do a global search/replace on a big table?