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

                                                                                           

Author

  • Sridhar Venkatachalam

    With close to 10 years on Experience in data science and machine learning Have extensively worked on programming languages like R, Python (Pandas), SAS, Pyspark.