Skip to main content

Module property_graph

Module property_graph 

Source
Expand description

The table clauses of CREATE PROPERTY GRAPH: the subset of SQL/PGQ Ursa supports, and clear errors for the rest.

CREATE [OR REPLACE] PROPERTY GRAPH [IF NOT EXISTS] name
  [VERTEX TABLES ( table KEY (column) )]
  EDGE TABLES (
    table SOURCE KEY (column) [REFERENCES vertex_table (key)]
          DESTINATION KEY (column) [REFERENCES vertex_table (key)]
  )

SQL/PGQ allows more: several vertex and edge tables, AS alias, LABEL, DEFAULT LABEL, PROPERTIES, NO PROPERTIES, an edge table KEY, SOURCE vertex_table without KEY, and multi-column keys. Each is recognised and rejected as not supported yet, never parsed as something else. NODE TABLES and RELATIONSHIP TABLES, SQL/PGQ’s synonyms, are accepted.

Structs§

EdgeTableDef
EDGE TABLES (table SOURCE … DESTINATION …).
EndpointDef
KEY (key) [REFERENCES table (column)], after SOURCE or DESTINATION.
References
REFERENCES table (column).
VertexTableDef
VERTEX TABLES (table KEY (key)).