PostgreSQL REVERSE() Function

The PostgreSQL REVERSE() function returns a string with the characters in reverse order. This function is safe to use with a string containing multi-byte characters.

Syntax

REVERSE(string)

Parameters

Return Value

Returns a string with the characters in reverse order of the specified string.

Example 1:

The example below shows the usage of REVERSE() function.

SELECT REVERSE('12345');
Result: '54321'

SELECT REVERSE('ABCDE');
Result: 'EDCBA'

SELECT REVERSE(12345);
Result: '54321'

SELECT REVERSE('Reverse this String');
Result: 'gnirtS siht esreveR'

Example 2:

Consider a database table called Employee with the following records:

The query mentioned below is used to reverse the records of City column.

SELECT *, REVERSE(City) AS REVERSE_String FROM Employee;

The query will produce the following result: