C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations.
pgext.cloud · Source code · Documentation · License text · Control file
| Package | sql_saga |
|---|---|
| Version | 1.0 |
| PostgreSQL versions | 18 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | No |
| Schema | sql_saga |
| Stars | 0 |
| Latest commit | 2026-02-23 |
| Catalogue updated | 2026-08-30 |
| btree_gist | support for indexing common datatypes in GiST |
| plpgsql | PL/pgSQL procedural language |
| sql_saga_native | Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. |
| pgtime | Temporal tables extension for PostgreSQL. Automatically tracks Transaction Time (system time) on any table using range types and a high-performance C-based AFTER ROW trigger. |
| temporal_tables | temporal tables |
| time_for_keys | C and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. |
| emaj | Enables fine-grained write logging and time travel on subsets of the database. |
| timeql | Native temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes. |
| temporal | C extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. |
| temporal_rtree | Experimental temporal R-tree access method implemented as a PostgreSQL extension. |
| pgsfti | PostgreSQL data type for simple trapezoidal fuzzy time intervals and fuzzy temporal relations. |
| sql_saga_native | Rust/pgrx companion library that accelerates sql_saga temporal_merge planning and executor introspection. |