Reverse the column value in Postgresql

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 1

 

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

Reverse the column value in postgresql 2