postgres string replace any code example

Example: replace postgresql

REPLACE(source, old_text, new_text );