Strings

REVERSE

Reverses a string.

Syntax

REVERSE(<text>)

Returns the same characters in reverse order: REVERSE('SQL') gives LQS. In practice it comes up less often than in interview puzzles: checking for a palindrome or comparing strings from the end.

Backwards

SELECT REVERSE('PostgreSQL') AS reversed;

reversed
LQSergtsoP

Is it a palindrome

SELECT 'level' = REVERSE('level') AS level_is_palindrome,

'SQL' = REVERSE('SQL') AS sql_is_palindrome;

level_is_palindrome	sql_is_palindrome
true	false

Watch out

It reverses characters, not bytes, so accented letters don't break: REVERSE('café') gives éfac.

You don't need REVERSE to take the end of a string: there's RIGHT and SPLIT_PART(<text>, '.', -1).

Related functions

RIGHT SPLIT_PART LENGTH