Top
Enterprise Postgres 17 SP1 Knowledge DataManagement FeatureUser's Guide

4.4 Storing Graph Data

Adding nodes and edges to a graph is done through Cypher queries using cypher functions, which are SQL functions provided by the graph management feature.

Example) Adding nodes and edges

SELECT * FROM cypher('new_graph', $$
 CREATE (:Person {name: 'Daedalus'})-[:FATHER_OF]->(:Person {name: 'Icarus'})
 $$) AS (a agtype);
 a
---
(0 rows)

In addition to the above, you can also load from a CSV file using the SQL functions load_labels_from_file and load_edges_from_file.