PostgreSQL 19 Beta Introduces SQL/PGQ for Property Graph Queries

PostgreSQL 19 Beta Release

PostgreSQL 19 is currently in beta, with beta 3 released on August 13, 2026. The official general availability release is anticipated around September or October 2026. This beta phase allows users to explore and test new features before the final release.

Introduction of SQL/PGQ

A significant new feature in PostgreSQL 19 is the implementation of SQL/PGQ, which is the property-graph component of the SQL:2023 standard. This addition allows users to define and query property graphs directly within the database using existing tables.

The SQL/PGQ functionality enables pattern matching for graph queries, which can simplify operations that previously required complex manual joins. For example, users can declare a property graph over existing tables and then query it using pattern matching syntax like `MATCH (a IS person)-[IS follows]->(b IS person)`.

Practical Application of Property Graphs

The property graph feature creates view-like objects that map table rows to vertices and edges without copying data. This allows for efficient querying of relationships. For instance, a `social` graph can be defined where `person` rows are vertices and `follows` rows are edges.

This capability simplifies querying multi-hop patterns, such as finding 'friends-of-friends,' without requiring self-joins. The `GRAPH_TABLE` function is used to execute these pattern-matching queries.

Context and Resources

The information regarding PostgreSQL 19 beta 3 is based on official release notes and the PostgreSQL source code. Users can refer to the official documentation and commit logs for detailed information on motivations, usage, and implementation specifics of each feature.