PostgreSQL Function Reference

RPAD

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

PostgreSQL 17.5

RPAD(str, len, pad_str)

str

The string to pad

len

The target length

pad_str

The pad string

Examples

PostgreSQL 17.5

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