PostgreSQL REVERSE Function

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

PostgreSQL REVERSE() function

REVERSE() function

The PostgreSQL reverse() function is used to arrange a string in reverse order.

Syntax :

reverse(<string>)

PostgreSQL Version : 9.3

Pictorial Presentation of PostgreSQL REVERSE() function

Example : PostgreSQL reverse() function :

In the example below, the string 'w3resource' have arranged in reverse order.

SELECT reverse('w3resource');

Output :

  reverse
------------
 ecruoser3w
(1 row)