📘Introducing SQL Notebooks: Tell stories using data.Read more →

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

Ready for a modern SQL editor?