How to Replace Substrings in PostgreSQL

The replace() function is used to change all occurrences of a certain substring to a new string. It accepts three parameters - the main string, the substring to be replaced, and the new string to be used.

select replace('This is old, really old', 'old', 'new');
 This is new, really new
database icon
SQL editing that just rocks
PopSQL and PostgreSQL, better together