Functions / String Functions And Operators

rpad

Extends the string to length length by appending the characters fill (a space by default).

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

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

rpad ( string text, length integer [, fill text ] ) → text

Extends the string to length length by appending the characters fill (a space by default). If the string is already longer than length then it is truncated.

rpad('hi', 5, 'xy') → hixyx

Version history 3

12 → 13 changed
8.0 → 8.1 changed
7.2 → 7.3 changed

Definition snapshot: b7bd9cda · English manual source