I am trying to replicate the following code in SQL Server to PostgreSQL: Required output Answer You can use generate_series() Online example

I am trying to replicate the following code in SQL Server to PostgreSQL:

declare @row int = 1
while (@row < 6)
begin
    print replicate('* ', @row)
    set @row = @row + 1
end;

​x
 
declare @row int = 1while (@row < 6)begin    print replicate('* ', @row)    set @row = @row + 1end;​

Required output

* 
* * 
* * * 
* * * * 
* * * * *

 
* * * * * * * * * * * * * * *​

You can use generate_series()

select rpad('*', i, '*')
from generate_series(1,5) as g(i)

 
select rpad('*', i, '*')from generate_series(1,5) as g(i)​