C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support.
pgext.cloud · Source code · Website · Documentation · License text · Control file
| Package | temporal |
|---|---|
| Version | 0.7.1 |
| Repository | Unspecified |
| Extension type | Standard |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 50 |
| Latest commit | 2012-01-24 |
| Latest release | 2011-06-03 |
| Catalogue updated | 2026-08-30 |
| pg_temporal | PostgreSQL extension adding Temporal ZonedDateTime support. |
| pgsfti | PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. |
| temporal_tables | temporal tables |
| time_for_keys | C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. |
| range_agg | range_agg: merge adjacent or overlapping PostgreSQL range values |
| sql_saga_native | Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. |
| lostgis | LostGIS spatial helper functions and types |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |