EXP 11: replace String in postgresql

Problem
Replace String "EJB" by "Bean" in postgresql

Solution
Using function regexp_replace(input_string, original_expression, new_expresstion)

Sample
UPDATE tbfunction
SET functionresource = regexp_replace(functionresource, 'EJB', 'Bean')