In order to remove a particular character from string in postgresql we will be using translate() function. With the help of translate() function a particular character from string is removed. Let’s see how to
- Remove a particular character from string in postgresql
We will be using summerfruits table.
Remove a particular character from string in postgresql
Removing a particular character from string in postgresql is accomplished by using translate() function as shown below
select *,translate(name,'e','') as New_Name from summerfruits
Character ‘e’ is removed from Colour column. So the resultant dataframe will be