periods

Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING

Overview

ID	Extension	Package	Version	Category	License	Language
1030	periods	periods	`1.2.3`	TIME	PostgreSQL	C

Attribute	Has Binary	Has Library	Need Load	Has DDL	Relocatable	Trusted
--s-d--	No	Yes	No	Yes	no	no

Relationships
Requires	btree_gist
See Also	timescaledb_toolkit timescaledb timeseries temporal_tables emaj table_version pg_cron pg_partman

Packages

Type	Repo	Version	PG Major Availability	Package Pattern	Dependencies
EL	PGDG	`1.2.3`	18 17 16 15 14 13	`periods_$v*`	-
Debian	PGDG	`1.2.3`	18 17 16 15 14 13	`postgresql-$v-periods`	-

Linux / PG	PG18	PG17	PG16	PG15	PG14	PG13
el8.x86_64	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3
el8.aarch64	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3
el9.x86_64	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3
el9.aarch64	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3
el10.x86_64	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3
el10.aarch64	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3	PIGSTY 1.2.3
d12.x86_64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
d12.aarch64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
d13.x86_64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
d13.aarch64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
u22.x86_64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
u22.aarch64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
u24.x86_64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3
u24.aarch64	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3	PGDG 1.2.3

Package	Version	OS	ORG	SIZE	File URL
`periods_18`	1.2.3	`el8.x86_64`	pigsty	43.7 KiB	periods_18-1.2.3-1PIGSTY.el8.x86_64.rpm
`periods_18`	1.2.3	`el8.aarch64`	pigsty	43.6 KiB	periods_18-1.2.3-1PIGSTY.el8.aarch64.rpm
`periods_18`	1.2.3	`el9.x86_64`	pigsty	42.0 KiB	periods_18-1.2.3-1PIGSTY.el9.x86_64.rpm
`periods_18`	1.2.3	`el9.aarch64`	pigsty	42.0 KiB	periods_18-1.2.3-1PIGSTY.el9.aarch64.rpm
`periods_18`	1.2.3	`el10.x86_64`	pigsty	42.1 KiB	periods_18-1.2.3-1PIGSTY.el10.x86_64.rpm
`periods_18`	1.2.3	`el10.aarch64`	pigsty	42.0 KiB	periods_18-1.2.3-1PIGSTY.el10.aarch64.rpm
`postgresql-18-periods`	1.2.3	`d12.x86_64`	pgdg	47.0 KiB	postgresql-18-periods_1.2.3-2.pgdg12+1_amd64.deb
`postgresql-18-periods`	1.2.3	`d12.aarch64`	pgdg	46.4 KiB	postgresql-18-periods_1.2.3-2.pgdg12+1_arm64.deb
`postgresql-18-periods`	1.2.3	`d13.x86_64`	pgdg	47.2 KiB	postgresql-18-periods_1.2.3-2.pgdg13+1_amd64.deb
`postgresql-18-periods`	1.2.3	`d13.aarch64`	pgdg	46.4 KiB	postgresql-18-periods_1.2.3-2.pgdg13+1_arm64.deb
`postgresql-18-periods`	1.2.3	`u22.x86_64`	pgdg	46.0 KiB	postgresql-18-periods_1.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-18-periods`	1.2.3	`u22.aarch64`	pgdg	45.5 KiB	postgresql-18-periods_1.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-18-periods`	1.2.3	`u24.x86_64`	pgdg	46.0 KiB	postgresql-18-periods_1.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-18-periods`	1.2.3	`u24.aarch64`	pgdg	45.4 KiB	postgresql-18-periods_1.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`periods_17`	1.2.3	`el8.x86_64`	pigsty	43.7 KiB	periods_17-1.2.3-1PIGSTY.el8.x86_64.rpm
`periods_17`	1.2.2	`el8.x86_64`	pgdg	44.4 KiB	periods_17-1.2.2-3PGDG.rhel8.x86_64.rpm
`periods_17`	1.2.3	`el8.aarch64`	pigsty	43.5 KiB	periods_17-1.2.3-1PIGSTY.el8.aarch64.rpm
`periods_17`	1.2.2	`el8.aarch64`	pgdg	44.1 KiB	periods_17-1.2.2-3PGDG.rhel8.aarch64.rpm
`periods_17`	1.2.3	`el9.x86_64`	pigsty	42.0 KiB	periods_17-1.2.3-1PIGSTY.el9.x86_64.rpm
`periods_17`	1.2.2	`el9.x86_64`	pgdg	42.4 KiB	periods_17-1.2.2-3PGDG.rhel9.x86_64.rpm
`periods_17`	1.2.3	`el9.aarch64`	pigsty	41.8 KiB	periods_17-1.2.3-1PIGSTY.el9.aarch64.rpm
`periods_17`	1.2.2	`el9.aarch64`	pgdg	42.1 KiB	periods_17-1.2.2-3PGDG.rhel9.aarch64.rpm
`periods_17`	1.2.3	`el10.x86_64`	pigsty	42.0 KiB	periods_17-1.2.3-1PIGSTY.el10.x86_64.rpm
`periods_17`	1.2.2	`el10.x86_64`	pgdg	42.7 KiB	periods_17-1.2.2-4PGDG.rhel10.x86_64.rpm
`periods_17`	1.2.3	`el10.aarch64`	pigsty	42.0 KiB	periods_17-1.2.3-1PIGSTY.el10.aarch64.rpm
`periods_17`	1.2.2	`el10.aarch64`	pgdg	42.5 KiB	periods_17-1.2.2-4PGDG.rhel10.aarch64.rpm
`postgresql-17-periods`	1.2.3	`d12.x86_64`	pgdg	47.0 KiB	postgresql-17-periods_1.2.3-2.pgdg12+1_amd64.deb
`postgresql-17-periods`	1.2.3	`d12.aarch64`	pgdg	46.3 KiB	postgresql-17-periods_1.2.3-2.pgdg12+1_arm64.deb
`postgresql-17-periods`	1.2.3	`d13.x86_64`	pgdg	47.2 KiB	postgresql-17-periods_1.2.3-2.pgdg13+1_amd64.deb
`postgresql-17-periods`	1.2.3	`d13.aarch64`	pgdg	46.5 KiB	postgresql-17-periods_1.2.3-2.pgdg13+1_arm64.deb
`postgresql-17-periods`	1.2.3	`u22.x86_64`	pgdg	50.1 KiB	postgresql-17-periods_1.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-17-periods`	1.2.3	`u22.aarch64`	pgdg	49.6 KiB	postgresql-17-periods_1.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-17-periods`	1.2.3	`u24.x86_64`	pgdg	46.1 KiB	postgresql-17-periods_1.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-17-periods`	1.2.3	`u24.aarch64`	pgdg	45.3 KiB	postgresql-17-periods_1.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`periods_16`	1.2.3	`el8.x86_64`	pigsty	43.7 KiB	periods_16-1.2.3-1PIGSTY.el8.x86_64.rpm
`periods_16`	1.2.2	`el8.x86_64`	pgdg	44.2 KiB	periods_16-1.2.2-1.rhel8.1.x86_64.rpm
`periods_16`	1.2.3	`el8.aarch64`	pigsty	43.5 KiB	periods_16-1.2.3-1PIGSTY.el8.aarch64.rpm
`periods_16`	1.2.2	`el8.aarch64`	pgdg	43.9 KiB	periods_16-1.2.2-1.rhel8.1.aarch64.rpm
`periods_16`	1.2.3	`el9.x86_64`	pigsty	41.9 KiB	periods_16-1.2.3-1PIGSTY.el9.x86_64.rpm
`periods_16`	1.2.2	`el9.x86_64`	pgdg	42.1 KiB	periods_16-1.2.2-1.rhel9.1.x86_64.rpm
`periods_16`	1.2.3	`el9.aarch64`	pigsty	41.9 KiB	periods_16-1.2.3-1PIGSTY.el9.aarch64.rpm
`periods_16`	1.2.2	`el9.aarch64`	pgdg	41.6 KiB	periods_16-1.2.2-1.rhel9.1.aarch64.rpm
`periods_16`	1.2.3	`el10.x86_64`	pigsty	42.0 KiB	periods_16-1.2.3-1PIGSTY.el10.x86_64.rpm
`periods_16`	1.2.2	`el10.x86_64`	pgdg	42.7 KiB	periods_16-1.2.2-4PGDG.rhel10.x86_64.rpm
`periods_16`	1.2.3	`el10.aarch64`	pigsty	42.0 KiB	periods_16-1.2.3-1PIGSTY.el10.aarch64.rpm
`periods_16`	1.2.2	`el10.aarch64`	pgdg	42.5 KiB	periods_16-1.2.2-4PGDG.rhel10.aarch64.rpm
`postgresql-16-periods`	1.2.3	`d12.x86_64`	pgdg	47.0 KiB	postgresql-16-periods_1.2.3-2.pgdg12+1_amd64.deb
`postgresql-16-periods`	1.2.3	`d12.aarch64`	pgdg	46.3 KiB	postgresql-16-periods_1.2.3-2.pgdg12+1_arm64.deb
`postgresql-16-periods`	1.2.3	`d13.x86_64`	pgdg	47.2 KiB	postgresql-16-periods_1.2.3-2.pgdg13+1_amd64.deb
`postgresql-16-periods`	1.2.3	`d13.aarch64`	pgdg	46.5 KiB	postgresql-16-periods_1.2.3-2.pgdg13+1_arm64.deb
`postgresql-16-periods`	1.2.3	`u22.x86_64`	pgdg	49.7 KiB	postgresql-16-periods_1.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-16-periods`	1.2.3	`u22.aarch64`	pgdg	49.2 KiB	postgresql-16-periods_1.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-16-periods`	1.2.3	`u24.x86_64`	pgdg	46.0 KiB	postgresql-16-periods_1.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-16-periods`	1.2.3	`u24.aarch64`	pgdg	45.4 KiB	postgresql-16-periods_1.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`periods_15`	1.2.3	`el8.x86_64`	pigsty	43.7 KiB	periods_15-1.2.3-1PIGSTY.el8.x86_64.rpm
`periods_15`	1.2.2	`el8.x86_64`	pgdg	44.2 KiB	periods_15-1.2.2-1.rhel8.x86_64.rpm
`periods_15`	1.2	`el8.x86_64`	pgdg	60.8 KiB	periods_15-1.2-2.rhel8.x86_64.rpm
`periods_15`	1.2.3	`el8.aarch64`	pigsty	43.6 KiB	periods_15-1.2.3-1PIGSTY.el8.aarch64.rpm
`periods_15`	1.2.2	`el8.aarch64`	pgdg	43.9 KiB	periods_15-1.2.2-1.rhel8.aarch64.rpm
`periods_15`	1.2	`el8.aarch64`	pgdg	60.4 KiB	periods_15-1.2-2.rhel8.aarch64.rpm
`periods_15`	1.2.3	`el9.x86_64`	pigsty	42.0 KiB	periods_15-1.2.3-1PIGSTY.el9.x86_64.rpm
`periods_15`	1.2.2	`el9.x86_64`	pgdg	42.1 KiB	periods_15-1.2.2-1.rhel9.x86_64.rpm
`periods_15`	1.2	`el9.x86_64`	pgdg	59.8 KiB	periods_15-1.2-2.rhel9.x86_64.rpm
`periods_15`	1.2.3	`el9.aarch64`	pigsty	41.9 KiB	periods_15-1.2.3-1PIGSTY.el9.aarch64.rpm
`periods_15`	1.2.2	`el9.aarch64`	pgdg	41.6 KiB	periods_15-1.2.2-1.rhel9.aarch64.rpm
`periods_15`	1.2	`el9.aarch64`	pgdg	59.2 KiB	periods_15-1.2-2.rhel9.aarch64.rpm
`periods_15`	1.2.3	`el10.x86_64`	pigsty	42.0 KiB	periods_15-1.2.3-1PIGSTY.el10.x86_64.rpm
`periods_15`	1.2.2	`el10.x86_64`	pgdg	42.7 KiB	periods_15-1.2.2-4PGDG.rhel10.x86_64.rpm
`periods_15`	1.2.3	`el10.aarch64`	pigsty	42.0 KiB	periods_15-1.2.3-1PIGSTY.el10.aarch64.rpm
`periods_15`	1.2.2	`el10.aarch64`	pgdg	42.5 KiB	periods_15-1.2.2-4PGDG.rhel10.aarch64.rpm
`postgresql-15-periods`	1.2.3	`d12.x86_64`	pgdg	46.9 KiB	postgresql-15-periods_1.2.3-2.pgdg12+1_amd64.deb
`postgresql-15-periods`	1.2.3	`d12.aarch64`	pgdg	46.3 KiB	postgresql-15-periods_1.2.3-2.pgdg12+1_arm64.deb
`postgresql-15-periods`	1.2.3	`d13.x86_64`	pgdg	47.2 KiB	postgresql-15-periods_1.2.3-2.pgdg13+1_amd64.deb
`postgresql-15-periods`	1.2.3	`d13.aarch64`	pgdg	46.5 KiB	postgresql-15-periods_1.2.3-2.pgdg13+1_arm64.deb
`postgresql-15-periods`	1.2.3	`u22.x86_64`	pgdg	49.7 KiB	postgresql-15-periods_1.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-15-periods`	1.2.3	`u22.aarch64`	pgdg	49.3 KiB	postgresql-15-periods_1.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-15-periods`	1.2.3	`u24.x86_64`	pgdg	46.0 KiB	postgresql-15-periods_1.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-15-periods`	1.2.3	`u24.aarch64`	pgdg	45.3 KiB	postgresql-15-periods_1.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`periods_14`	1.2.3	`el8.x86_64`	pigsty	43.7 KiB	periods_14-1.2.3-1PIGSTY.el8.x86_64.rpm
`periods_14`	1.2.2	`el8.x86_64`	pgdg	44.2 KiB	periods_14-1.2.2-1.rhel8.x86_64.rpm
`periods_14`	1.2	`el8.x86_64`	pgdg	61.2 KiB	periods_14-1.2-2.rhel8.x86_64.rpm
`periods_14`	1.2.3	`el8.aarch64`	pigsty	43.6 KiB	periods_14-1.2.3-1PIGSTY.el8.aarch64.rpm
`periods_14`	1.2.2	`el8.aarch64`	pgdg	43.9 KiB	periods_14-1.2.2-1.rhel8.aarch64.rpm
`periods_14`	1.2	`el8.aarch64`	pgdg	60.2 KiB	periods_14-1.2-2.rhel8.aarch64.rpm
`periods_14`	1.2.3	`el9.x86_64`	pigsty	42.0 KiB	periods_14-1.2.3-1PIGSTY.el9.x86_64.rpm
`periods_14`	1.2.2	`el9.x86_64`	pgdg	42.1 KiB	periods_14-1.2.2-1.rhel9.x86_64.rpm
`periods_14`	1.2.3	`el9.aarch64`	pigsty	41.9 KiB	periods_14-1.2.3-1PIGSTY.el9.aarch64.rpm
`periods_14`	1.2.2	`el9.aarch64`	pgdg	41.6 KiB	periods_14-1.2.2-1.rhel9.aarch64.rpm
`periods_14`	1.2	`el9.aarch64`	pgdg	59.0 KiB	periods_14-1.2-2.rhel9.aarch64.rpm
`periods_14`	1.2.3	`el10.x86_64`	pigsty	42.0 KiB	periods_14-1.2.3-1PIGSTY.el10.x86_64.rpm
`periods_14`	1.2.2	`el10.x86_64`	pgdg	42.7 KiB	periods_14-1.2.2-4PGDG.rhel10.x86_64.rpm
`periods_14`	1.2.3	`el10.aarch64`	pigsty	42.0 KiB	periods_14-1.2.3-1PIGSTY.el10.aarch64.rpm
`periods_14`	1.2.2	`el10.aarch64`	pgdg	42.5 KiB	periods_14-1.2.2-4PGDG.rhel10.aarch64.rpm
`postgresql-14-periods`	1.2.3	`d12.x86_64`	pgdg	46.9 KiB	postgresql-14-periods_1.2.3-2.pgdg12+1_amd64.deb
`postgresql-14-periods`	1.2.3	`d12.aarch64`	pgdg	46.2 KiB	postgresql-14-periods_1.2.3-2.pgdg12+1_arm64.deb
`postgresql-14-periods`	1.2.3	`d13.x86_64`	pgdg	47.1 KiB	postgresql-14-periods_1.2.3-2.pgdg13+1_amd64.deb
`postgresql-14-periods`	1.2.3	`d13.aarch64`	pgdg	46.5 KiB	postgresql-14-periods_1.2.3-2.pgdg13+1_arm64.deb
`postgresql-14-periods`	1.2.3	`u22.x86_64`	pgdg	49.6 KiB	postgresql-14-periods_1.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-14-periods`	1.2.3	`u22.aarch64`	pgdg	49.2 KiB	postgresql-14-periods_1.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-14-periods`	1.2.3	`u24.x86_64`	pgdg	46.0 KiB	postgresql-14-periods_1.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-14-periods`	1.2.3	`u24.aarch64`	pgdg	45.3 KiB	postgresql-14-periods_1.2.3-2.pgdg24.04+1_arm64.deb

Package	Version	OS	ORG	SIZE	File URL
`periods_13`	1.2.3	`el8.x86_64`	pigsty	43.6 KiB	periods_13-1.2.3-1PIGSTY.el8.x86_64.rpm
`periods_13`	1.2.2	`el8.x86_64`	pgdg	44.1 KiB	periods_13-1.2.2-1.rhel8.x86_64.rpm
`periods_13`	1.2	`el8.x86_64`	pgdg	60.5 KiB	periods_13-1.2-1.rhel8.x86_64.rpm
`periods_13`	1.2.3	`el8.aarch64`	pigsty	43.6 KiB	periods_13-1.2.3-1PIGSTY.el8.aarch64.rpm
`periods_13`	1.2.2	`el8.aarch64`	pgdg	43.9 KiB	periods_13-1.2.2-1.rhel8.aarch64.rpm
`periods_13`	1.2	`el8.aarch64`	pgdg	60.2 KiB	periods_13-1.2-2.rhel8.aarch64.rpm
`periods_13`	1.2.3	`el9.x86_64`	pigsty	42.0 KiB	periods_13-1.2.3-1PIGSTY.el9.x86_64.rpm
`periods_13`	1.2.2	`el9.x86_64`	pgdg	42.1 KiB	periods_13-1.2.2-1.rhel9.x86_64.rpm
`periods_13`	1.2.3	`el9.aarch64`	pigsty	41.8 KiB	periods_13-1.2.3-1PIGSTY.el9.aarch64.rpm
`periods_13`	1.2.2	`el9.aarch64`	pgdg	41.6 KiB	periods_13-1.2.2-1.rhel9.aarch64.rpm
`periods_13`	1.2	`el9.aarch64`	pgdg	59.0 KiB	periods_13-1.2-2.rhel9.aarch64.rpm
`periods_13`	1.2.3	`el10.x86_64`	pigsty	42.0 KiB	periods_13-1.2.3-1PIGSTY.el10.x86_64.rpm
`periods_13`	1.2.2	`el10.x86_64`	pgdg	42.6 KiB	periods_13-1.2.2-4PGDG.rhel10.x86_64.rpm
`periods_13`	1.2.3	`el10.aarch64`	pigsty	42.1 KiB	periods_13-1.2.3-1PIGSTY.el10.aarch64.rpm
`periods_13`	1.2.2	`el10.aarch64`	pgdg	42.6 KiB	periods_13-1.2.2-4PGDG.rhel10.aarch64.rpm
`postgresql-13-periods`	1.2.3	`d12.x86_64`	pgdg	46.4 KiB	postgresql-13-periods_1.2.3-2.pgdg12+1_amd64.deb
`postgresql-13-periods`	1.2.3	`d12.aarch64`	pgdg	46.4 KiB	postgresql-13-periods_1.2.3-2.pgdg12+1_arm64.deb
`postgresql-13-periods`	1.2.3	`d13.x86_64`	pgdg	46.6 KiB	postgresql-13-periods_1.2.3-2.pgdg13+1_amd64.deb
`postgresql-13-periods`	1.2.3	`d13.aarch64`	pgdg	46.3 KiB	postgresql-13-periods_1.2.3-2.pgdg13+1_arm64.deb
`postgresql-13-periods`	1.2.3	`u22.x86_64`	pgdg	49.3 KiB	postgresql-13-periods_1.2.3-2.pgdg22.04+1_amd64.deb
`postgresql-13-periods`	1.2.3	`u22.aarch64`	pgdg	48.9 KiB	postgresql-13-periods_1.2.3-2.pgdg22.04+1_arm64.deb
`postgresql-13-periods`	1.2.3	`u24.x86_64`	pgdg	45.5 KiB	postgresql-13-periods_1.2.3-2.pgdg24.04+1_amd64.deb
`postgresql-13-periods`	1.2.3	`u24.aarch64`	pgdg	45.2 KiB	postgresql-13-periods_1.2.3-2.pgdg24.04+1_arm64.deb

Source

Repository

github.com/xocolatl/periods

Source Tarball

periods-1.2.3.tar.gz

pig build get periods; # get periods source code
pig build dep periods; # install build dependencies
pig build pkg periods; # build extension rpm or deb
pig build ext periods; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install periods; # install by extension name, for the current active PG version
pig ext install periods; # install via package alias, for the active PG version
pig ext install periods -v 18;   # install for PG 18
pig ext install periods -v 17;   # install for PG 17
pig ext install periods -v 16;   # install for PG 16
pig ext install periods -v 15;   # install for PG 15
pig ext install periods -v 14;   # install for PG 14
pig ext install periods -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION periods;

Last updated on 2025-11-02

timeseries temporal_tables