I have a table that looks like this

I want to get the Output like this:-

. . . . . . . . . . . . . . . .

CodePudding user response：

You can use a cross join against generate_series()

select t.*
from the_table t
  cross join generate_series(1, t.count) as g
order by t.id;

Online example

CodePudding user response：

Using RECURSIVE CTE you can do:

WITH RECURSIVE cte as (
  SELECT 1 as x,m.* FROM mytable m
  union all
  SELECT x 1,m.* 
  FROM cte,mytable m 
  WHERE x<m.count)
SELECT DISTINCT * 
FROM cte
ORDER BY count DESC;

see: DBFIDDLE

more info:

• WITH Queries (Common Table Expressions)
• Learn PostgreSQL Recursive Query By Example