PostgreSQL Function Reference

REPEAT

Repeats a string a specified number of times.

PostgreSQL 17.5

REPEAT(str, count)

str

The string to repeat

count

Number of times to repeat

Examples

PostgreSQL 17.5

SELECT REPEAT('111', 3)