REPEAT returns a VARCHAR value containing a specified string repeated a specified number of times.
Syntax
REPEAT ( string , repetitions )
Semantics
string |
(CHAR or VARCHAR) is the string to repeat |
repetitions |
(INTEGER) is the number of times to repeat the string |
Examples
=> SELECT REPEAT ('1234', 5);
repeat
----------------------
12341234123412341234
(1 row)