translate(s, f, r): Returns the character string s, with any found characters from string f replaced with corresponding character in string r : translate « String Functions « PostgreSQL
translate(s, f, r): Returns the character string s, with any found characters from string f replaced with corresponding character in string r
postgres=# --- translate(s, f, r): Returns the character string s, with any found characters from string f replaced with corresponding character in string r
postgres=#
postgres=# SELECT translate('I am an example?', '?', '!');
translate
------------------
I am an example!
(1 row)