 PostgreSQL `generate_series`

ID: postgresql-generate-series

Ciro Santilli 35  Updated 2025-02-11  +Created 2024-12-31

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);

 New to topics? Read the docs here!