Functions / String Functions And Operators

lpad

Extends the string to length length by prepending 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

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

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

lpad('hi', 5, 'xy') → xyxhi

Version history 3

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

Definition snapshot: b7bd9cda · English manual source