PostgreSQL 19 introduces SQL/PGQ support, allowing property graphs to be defined as read-only views over existing relational tables. A property graph consists of vertices and edges with labels and properties mapped from tables and columns. Using CREATE PROPERTY GRAPH, developers can define vertex tables and edge tables with source/destination relationships, then query them with graph pattern matching syntax via GRAPH_TABLE and MATCH clauses. Labels can rename tables, apply multiple labels to a single table, and expose different property sets — enabling flexible graph views over the same relational data. Relational and graph queries can be combined in a single query, sharing the same planning and execution infrastructure.
3.9K Impressions