↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Functions / String Functions And Operators

reverse

Read the PG 18 manual

Reverses the order of the characters in the string.

Reading PG 18current·documented in 17 of 27 versions, 9.1 to 20

7.17.27.37.48.08.18.28.38.49.09.19.29.39.49.59.61011121314151617181920

Signatures & examples

reverse ( text ) → text
Reverses the order of the characters in the string.
reverse('abcde') → edcba
reverse ( bytea ) → bytea
Reverses the order of the bytes in the binary string.
reverse('\xabcd'::bytea) → \xcdab
Version history 3
  1. 17 → 18 changed
  2. 12 → 13 changed
  3. 9.0 → 9.1 added

Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source