postgresql string replace code example

Example: replace postgresql

REPLACE(source, old_text, new_text );