Postgres 19 beta 3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 19beta3 (Debian 19~beta3-1.pgdg13+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 14.2.0-19) 14.2.0, 64-bit

SELECT 1

create table person (id int primary key, name text);
insert into person values (1,'alice'),(2,'bob'),(3,'carol');

create table knows (a int, b int);
insert into knows values (1,2),(2,3);

CREATE TABLE

INSERT 0 3

CREATE TABLE

INSERT 0 2

-- property graphs are new in PostgreSQL 19
create property graph social
  vertex tables (person key (id) label person properties (id, name))
  edge tables (knows key (a,b)
    source key (a) references person (id)
    destination key (b) references person (id)
    label knows);

CREATE PROPERTY GRAPH

select *
from graph_table (social
  match (p is person)-[k is knows]->(q is person)
  columns (p.name as knower, q.name as known));

knower
known

alice
bob

bob
carol

SELECT 2