А в чем тут проблема?:

update banner set description = replace(description, 'Искусство', 'Искуство');

ERROR: Function 'replace(text, unknown, unknown)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts