Cheat Sheet logoCheat Sheet Today
PostgreSQL Cheat Sheet/Generate date series

Generate date or timestamp ranges without a table.

Back to sheetBrowse commands
Sign in to save
Section: JSONB, Arrays, and Date/Time Recipes

Generate date series

sql
sql
SELECT generate_series(date '2026-01-01', date '2026-01-07', interval '1 day');
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing JSONB, Arrays, and Date/Time Recipes
Connect to a database
Open an interactive psql session to a database.
OpenIn sheetbash
Create database
Create a new database in the cluster.
OpenIn sheetsql
Create schema
Create a namespace for objects.
OpenIn sheetsql
Insert row
Insert one row into a table.
OpenIn sheetsql
Basic SELECT
Fetch a sorted subset of rows.
OpenIn sheetsql
Create index
Add a basic B-tree index to speed lookups.
OpenIn sheetsql