 PostgreSQL generate_series (source code)

by Ciro Santilli (@cirosantilli, 37)

= 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