postgres replace string code example

Example: replace postgresql

REPLACE(source, old_text, new_text );