 Source: cirosantilli/postgresql-generate-series

= PostgreSQL `generate_series`

https://www.postgresql.org/docs/17/functions-srf.html

Pattern you always want to generate <Generate random text in PostgreSQL>:
``
CREATE TABLE "mytable" ("i" INTEGER, "j" INTEGER);
INSERT INTO "mytable" SELECT i, i*2 FROM generate_series(1, 10) as s(i);
``

 Back to article page