Simple translate function example : translate « String Functions « PostgreSQL






  1. PostgreSQL
  2. String Functions
  3. translate

Simple translate function example


postgres=# SELECT translate('This is a mistake.', 'is', 'was');
     translate
--------------------
 Thwa wa a mwatake.
(1 row)

postgres=#








Related examples in the same category

1.translate(name, 'aeiouAEIOU', ''): Replace all vowels with nothing
2.translate(s, f, r): Returns the character string s, with any found characters from string f replaced with corresponding character in string r