Can you reverse a string in PostgreSQL?

Question

I'm interested in reversing a string in PostgreSQL.

Pat · Accepted Answer · 2012-02-14 18:11:32Z

7

PostgreSQL 9.1 and later includes a built-in function

 reverse(text)

answered Feb 14, 2012 at 18:11

Pat

36.8k18 gold badges75 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tomasz Kowalczyk · Accepted Answer · 2010-09-11 00:57:19Z

2

Here you have reversing string function for PostreSQL:

answered Sep 11, 2010 at 0:57

Tomasz Kowalczyk

10.5k6 gold badges56 silver badges70 bronze badges

Super Kai - Kazuya Ito · Accepted Answer · 2024-02-04 19:23:44Z

-1

You can use reverse() as shown below:

SELECT reverse('hello'); -- olleh

answered Feb 4, 2024 at 19:23

42.8k23 gold badges259 silver badges257 bronze badges

This answer was already given 12 years ago stackoverflow.com/a/9281992/73226