Jump to: navigation, search

PostgreSQL REPEAT

From w3cyberlearnings

Contents

Postgresql repeat

Repeat string the specified number of times

Syntax repeat

repeat(string, number)

Example 1

test2=# SELECT repeat('Love ',4);
        repeat        
----------------------
 Love Love Love Love 
(1 row)

Example 2

test2=# SELECT repeat(' &---& ',4);
            repeat            
------------------------------
  &---&  &---&  &---&  &---& 
(1 row)

Related Links


Navigation
Web
SQL
MISC
References