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

Project Samples

Temporal Tables Screenshot 1

Project Activity

See All Activity >

Categories

SQL Clients

License

MIT License

Follow Temporal Tables

Temporal Tables Web Site

Other Useful Business Software
Our Free Plans just got better! | Auth0 Icon
Our Free Plans just got better! | Auth0

With up to 25k MAUs and unlimited Okta connections, our Free Plan lets you focus on what you do best—building great apps.

You asked, we delivered! Auth0 is excited to expand our Free and Paid plans to include more options so you can focus on building, deploying, and scaling applications without having to worry about your security. Auth0 now, thank yourself later.
Try free now
Rate This Project
Login To Rate This Project

User Reviews

Be the first to post a review of Temporal Tables!

Additional Project Details

Operating Systems

Linux, Mac, Windows

Programming Language

PL/SQL

Related Categories

PL/SQL SQL Clients

Registered

2025-06-16
Report inappropriate content