generate array of unique uuid in postgreSQL
Assuming you don't actually want them in an array, since you are unnesting it right away, here's how to generate a table of any amount of UUIDs:

WITH RECURSIVE genx(n, uu) AS (
  VALUES (1, uuid_generate_v4())
  UNION ALL
  SELECT n + 1, uuid_generate_v4()
  FROM genx WHERE n &lt; 30
) SELECT uu FROM genx;


Change the 30 to as many as you want!