What does `GENERATE_SERIES(1, 10)` do in PostgreSQL?

Advanced SQL Developer Medium

Advanced SQL Developer — Medium

What does `GENERATE_SERIES(1, 10)` do in PostgreSQL?

Key points

  • `GENERATE_SERIES` creates a virtual table with a sequence of integers.
  • It is commonly used for generating test data or date ranges.
  • This function does not create a permanent sequence object.
  • It does not generate random series IDs for insert operations.

Ready to go further?

Related questions