PostgreSQL extension adding Temporal ZonedDateTime support.
pgext.cloud · Source code · Documentation · Control file
| Package | pg_temporal |
|---|---|
| Version | 1.0.0 |
| PostgreSQL versions | 12 · 13 · 14 · 15 · 16 · 17 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Stars | 0 |
| Latest commit | 2025-02-25 |
| Catalogue updated | 2026-08-30 |
| temporal | C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. |
| temporal_tables | temporal tables |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |
| temporal_rtree | Experimental temporal R-tree access method implemented as a PostgreSQL extension. |
| sql_saga | C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations. |
| pgsfti | PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. |
| time_for_keys | C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. |
| timeql | Native temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes. |