generate_date_series is an extension that provides a generate_series()-like function that takes date inputs and an integer interval (representing days).

For function documentation and examples, see the generate_date_series.md file.

Requirements: PostgreSQL 9.2 or greater.

In the directory where you downloaded generate_date_series, run

make && make install

Log into PostgreSQL.

Run the following command:

CREATE EXTENSION generate_date_series;

To all any user to execute this new function, run the following grant:

GRANTE execute on generate_date_series(date,date,integer) to public;

Run "make && make install" same as above to put the script files and libraries in place. Then run the following in PostgreSQL itself:

ALTER EXTENSION generate_date_series UPDATE TO '<latest version>';