temporal_tables is a PostgreSQL extension that adds temporal support to tables by automatically tracking row history. It enables versioned records, letting users query data as it existed at any point in time. This is ideal for audit logging, data versioning, and time-travel queries without needing manual triggers or archive tables.
Features
- Adds system-versioned tables to PostgreSQL
- Automatically logs row history on updates and deletes
- Supports time-travel queries with valid time ranges
- Uses native PostgreSQL features and triggers
- Simple installation and integration with existing schemas
- Useful for auditing, compliance, and data recovery
Categories
SQL ClientsLicense
MIT LicenseFollow Temporal Tables
Other Useful Business Software
Enterprise-grade ITSM, for every business
Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.
Rate This Project
Login To Rate This Project
User Reviews
Be the first to post a review of Temporal Tables!