SQL · String functions

repeat()

Repeats a string. PostgreSQL and MySQL; not built into SQLite.

sqlRunnable example sql course

Syntax

repeat(text, times)

Example

Open in the lab

-- PostgreSQL
-- SELECT repeat('ab', 3);

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.