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.

Code:

SELECT reverse('w3resource');

Sample Output:

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

Previous: RIGHT function
Next: Date and Time Operators