Removing a set of letters from a string

Question

I want to remove the vowels from the email id. Which function should I use? I am trying to find the difference between `translate` and `replace` in postgresql but didn't get the exact difference

Accepted Answer

`translate()` replaces a set of single characters (passed as a string) with another set of characters (also passed as a string), for example:

```
translate('abcdef', 'ace', 'XYZ') --> 'XbYdZf'
```

`replace()` replaces occurrences of a string of arbitrary length with another string:

```
replace('abcdef', 'bc', 'FOO') --> 'aFOOdef'
```

Removing a set of letters from a string

Solution

Problem