postgres select replace varchar code example

Example: replace postgresql

REPLACE(source, old_text, new_text );