Jump to: navigation, search

PostgreSQL REVERSE

From w3cyberlearnings

Contents

Postgresql reverse

This function reverses a string.

Syntax reverse

 reverse(string)

Example 1


postgres=# SELECT reverse('abc');
 reverse 
---------
 cba
(1 row)

Example 2

postgres=# SELECT reverse('1234');
 reverse 
---------
 4321
(1 row)

Example 3

postgres=# SELECT name,reverse(name)
postgres-# FROM employee;
  name  | reverse 
--------+---------
 John   | nhoJ
 Week   | keeW
 Christ | tsirhC
(3 rows)

Related Links


Navigation
Web
SQL
MISC
References