REVERSE

Return a character string with its characters in reverse order.

REVERSE(string)
For example:
premdb=# SELECT REVERSE(name) FROM team WHERE city='Manchester';
      reverse      
-------------------
 ytiC retsehcnaM
 detinU retsehcnaM
(2 rows)