SQL/PGQ: Postgres as Graph DB

 Handling graphs with SQL/PGQ in PostgreSQL | CYBERTEC PostgreSQL | Services & Support

Starting with version 19 of PostgreSQL users will be able to enjoy something exceptionally useful which will help developers to build even more powerful applications even more quickly. SQL/PGQ — the ISO/IEC 9075-16 (2023) syntax for querying graphs that live in regular relational tables - will be available.

Defining a property graph in PostgreSQL

First we have to define a property graph. Here is how it works:

PgSQL

CREATE PROPERTY GRAPH social      VERTEX TABLES (          person KEY (id) LABEL person PROPERTIES (id, name, age, city)      )      EDGE TABLES (          knows              SOURCE      KEY (a) REFERENCES person (id)              DESTINATION KEY (b) REFERENCES person (id)              LABEL knows PROPERTIES (since)      ); tutorial=# SELECT name FROM GRAPH_TABLE (social MATCH (p IS person) COLUMNS (p.name) ) ORDER BY name;