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

Better SQL for the people

Get more done with PopSQL and PostgreSQL