Extensions
periods

periods

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 Compatibility Package Pattern Dependencies
EXT
PIGSTY
 1.2.3
18
17
16
15
14
13
 periods -
RPM
PGDG
 1.2.3
18
17
16
15
14
13
 periods_$v* -
DEB
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 pkg periods;		# build spec not ready

Install

Make sure PGDG and PIGSTY repo available:

pig repo add pgdg pigsty -u   # add both repo and update cache

Install this extension with pig:

pig install periods;		# install via package name, for the active PG version

pig install periods -v 18;   # install for PG 18
pig install periods -v 17;   # install for PG 17
pig install periods -v 16;   # install for PG 16
pig install periods -v 15;   # install for PG 15
pig install periods -v 14;   # install for PG 14
pig install periods -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION periods CASCADE; -- requires btree_gist
Last updated on
timeseriestemporal_tables