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.
pgext.cloud · Source code · Documentation · Control file
| Package | pgtime |
|---|---|
| Version | 0.1 |
| Repository | Unspecified |
| Extension type | Standard |
| Project status | Active |
| Requires CREATE EXTENSION | Yes |
| Requires preload | No |
| Trusted | No |
| Relocatable | Yes |
| Stars | 1 |
| Latest commit | 2026-06-05 |
| Latest release | 2026-06-01 |
| Catalogue updated | 2026-08-30 |
| audit_stream | Postgres extension that emits audit-stream-py-compatible governance events on watched table CRUD via pg notify, plus a Python LISTEN bridge daemon. The database-tier governance producer for the Kinetic Gain Protocol Suite. |
| rppd | Trigger-based PostgreSQL event dispatcher that sends row changes over gRPC to a clustered Rust/Python execution service. |
| verisql | Audit-grade verification gateway for AI-generated SQL — catches silently wrong queries before they hit your dashboard, keeps tamper-evident audit trails, verifies migration equivalence. Zero LLM tokens for 90% of checks. |
| pg_py_plan_forwarding | Forward PostgreSQL planner and executor data to embedded Python callbacks |
| sql_saga | C and PL/pgSQL extension for valid-time temporal tables, temporal foreign keys, history-preserving views, and bulk temporal merge operations. |
| s2 | PL/Python functions for converting latitude/longitude to S2 cell IDs and tokens and navigating the S2 cell hierarchy |
| pgpyml | Run scikit-learn machine-learning models inside PostgreSQL through PL/Python functions and triggers. |
| pg_typescript | pg_typescript: TypeScript/JavaScript procedural language for PostgreSQL |
| I4R_AUDB_extension | AUDB operations for PostgreSQL int4range values. |
| panda_post | Python Pandas data in Postgres |