Temporal Tables

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

Project Activity

See All Activity >

License

MIT License

Follow Temporal Tables

Temporal Tables Web Site

Other Useful Business Software

Go From AI Idea to AI App Fast

One platform to build, fine-tune, and deploy ML models. No MLOps team required.

Access Gemini 3 and 200+ models. Build chatbots, agents, or custom models with built-in monitoring and scaling.

Try Free

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

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
Mason

Mason learns from every query you write. Seamlessly query, visualize and share data with your team. Generate SQL and tweak the result using our best-in-class AI assistant. Mason automatically recommends and completes your joins for you. Say goodbye to scrolling an endless list of tables. Connect...

See Software
DBeaver Community

DBeaver Community is a free, open-source database management tool recommended for personal projects. Manage and explore SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more. Connect to popular SQL databases (PostgreSQL, MySQL, SQL Server, Oracle, SQLite, etc.) SQL...

See Software
DataGrip

Meet DataGrip, our new database IDE that is tailored to suit the specific needs of professional SQL developers. Allows you to execute queries in different modes and provides a local history that keeps track of all your activity and protects you from losing your work. Lets you jump to any table,...

See Software
FlySpeed SQL Query

The visual query designer lets you create new SQL queries by drag'n'drop, and represent off-the-shelf queries visually. It makes SQL query analysis, creation, and modification much simpler. Using FlySpeed SQL Query, you can build parameterized queries, and browse data from linked tables via...

See Software

Report inappropriate content

Temporal Tables

Postgresql temporal_tables extension in PL/pgSQL

Get an email when there's a new version of Temporal Tables

Features

Project Samples

Project Activity

Categories

License

Follow Temporal Tables

User Reviews

Additional Project Details

Operating Systems

Programming Language

Related Categories

Registered