PostgreSQL 19 Interactive Tour

PostgreSQL 19, currently in beta with general availability expected in September or October 2026, introduces SQL/PGQ property graph queries as its headline feature, allowing users to declare graphs over existing tables and query them with pattern matching instead of manual joins. The release includes hands-on examples demonstrating new features, including multi-hop pattern matching that simplifies complex queries like finding friends-of-friends without self-joins. This article serves as a practical companion to the official release notes, with all examples tested against PostgreSQL 19 beta 3.