Contents
translate()
A system function for replacing sets of characters with another set
translate() is a system function for replacing sets of characters in a string with another set of characters.
translate() was added in PostgreSQL 6.1.
Usage
translate ( string text, from text, to text ) → text
Each character in the from string will be replaced by the corresponding character in the to string, if presnt in the source string. If a character in the from string does not have a corresponding character in the to string (i.e. the from string is longer than the to string), that character will be removed.
Change history
- PostgreSQL 6.1
- added (commit 83978e1e)
Examples
Basic execution of translate(), replacing occurences of b and r with p and o respectively:
postgres=# SELECT translate('foobar', 'br', 'po');
translate
-----------
foopao
(1 row)
Characters in the from string with no corresponding character in the to string (in this example: f) will be removed:
postgres=# SELECT translate('foobar', 'brf', 'po');
translate
-----------
oopao
(1 row)
translate() works with multibyte strings:
postgres=# SELECT translate('こん', 'ん', 'の');
translate
-----------
この
(1 row)
References
- PostgreSQL documentation: Other String Functions