In order to reverse the column value in postgresql we use REVERSE() function. REVERSE() function of column in postgresql reverse the value of the column. Let’s see how to
- Reverse the column value in postgresql.
Syntax of REVERSE():
REVERSE()
We will be using Zipcodes table.
Reverse the column value in Postgresql:
In order to reverse the column value in postgresql we use REVERSE() function.
select *,REVERSE(city) as Reverse_city FROM zipcodes
Reverse function of city column reverse the column so the resultant dataframe will be