REPLACE

Replaces all occurrences of characters in a string with another set of characters.

Behavior Type

Immutable

Syntax

REPLACE ('string', 'target', 'replacement' )

Parameters

string

The string to modify.

target

The characters in string to replace.

replacement

The characters to replace target.

Examples

=> SELECT REPLACE('Documentation%20Library', '%20', ' ');
        REPLACE
-----------------------
 Documentation Library
(1 row)
=> SELECT REPLACE('This & That', '&', 'and');
    REPLACE
---------------
 This and That
(1 row)
=> SELECT REPLACE('straße', 'ß', 'ss');
 REPLACE
---------
 strasse
(1 row)