PostgreSQL DummyData

with recursive Dumy  

AS 

(  

 SELECT 0 Seq  

 UNION ALL 

 SELECT Seq + 1 FROM Dumy  

 WHERE Seq + 1 <= 100000  

)  

SELECT Seq FROM Dumy;