.NET Data Community Standup: Temporal tables and constraints in SQL Server and PostgreSQL 18

Name: .NET Data Community Standup: Temporal tables and constraints in SQL Server and PostgreSQL 18
Uploaded: 2026-06-10T07:41:16+00:00
Description: Shay Rojansky and Jiri Cincura compare how SQL Server and PostgreSQL 18 approach temporal data, digging into SQL Server temporal tables versus PostgreSQL’s...

1 weeks ago by Shay Rojansky, Jiri Cincura

Shay Rojansky and Jiri Cincura compare how SQL Server and PostgreSQL 18 approach temporal data, digging into SQL Server temporal tables versus PostgreSQL’s new temporal constraint functionality and why they represent different concepts despite surface similarities.

Overview

The session takes a detailed look at two different approaches to storing and enforcing temporal data in relational databases:

SQL Server temporal tables (system-versioned tables)
PostgreSQL 18 temporal constraints, which may look similar at first glance but are designed around a different concept of temporal data

The presenters compare the two features and discuss what each model implies for representing time in data, enforcing rules with constraints, and working with temporal history in database design.