How can I generate a series of repeating numbers in PostgreSQL? September 16, 2023 by Tarik You could cross join it to a series of 3: SELECT a.n from generate_series(1, 100) as a(n), generate_series(1, 3)