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






  1. PostgreSQL
  2. String Functions
  3. translate

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)








Related examples in the same category

1.translate(name, 'aeiouAEIOU', ''): Replace all vowels with nothing
2.Simple translate function example