PostgreSQL Function Reference

LPAD

Pads the string on the left to the specified length with a pad string.

PostgreSQL 17.5

LPAD(str, len, pad_str)

str

The string to pad

len

The target length

pad_str

The pad string

Examples

PostgreSQL 17.5

SELECT LPAD('9', 5, '0')