periods
Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
Module:
Categories:
Overview
PGDG 1st Party Extension: periods
: Provide Standard SQL functionality for PERIODs and SYSTEM VERSIONING
Information
- Extension ID: 1030
- Extension Name:
periods
- Package Name:
periods
- Category:
TIME
- License: PostgreSQL
- Website: https://github.com/xocolatl/periods
- Language: C
- Extra Tags: N/A
- Comment: N/A
Metadata
- Latest Version: 1.2
- Postgres Support:
17
,16
,15
,14
,13
- Need Load: Shared library do not need explicit loading
- Need DDL: Need
CREATE EXTENSION
DDL - Relocatable: Can be installed into other schemas
- Trusted: Untrusted, Require Superuser to Create
- Schemas: N/A
- Requires:
btree_gist
RPM / DEB
- RPM Repo: PGDG
- RPM Name:
periods_$v*
- RPM Ver :
1.2
- RPM Deps: N/A
- DEB Repo: PGDG
- DEB Name:
postgresql-$v-periods
- DEB Ver :
1.2
- DEB Deps: N/A
Packages
Installation
Install periods
via the pig
CLI tool:
pig ext install periods
Install periods
via Pigsty playbook:
./pgsql.yml -t pg_extension -e '{"pg_extensions": ["periods"]}' # -l <cls>
Install periods
RPM from YUM repo directly:
dnf install periods_17*;
dnf install periods_16*;
dnf install periods_15*;
dnf install periods_14*;
dnf install periods_13*;
Install periods
DEB from APT repo directly:
apt install postgresql-17-periods;
apt install postgresql-16-periods;
apt install postgresql-15-periods;
apt install postgresql-14-periods;
apt install postgresql-13-periods;
Enable periods
extension on PostgreSQL cluster:
CREATE EXTENSION periods CASCADE;
Feedback
Was this page helpful?
Glad to hear it! Please tell us how we can improve.
Sorry to hear that. Please tell us how we can improve.