Question 89033 in PostgreSQL Question posted in
The official documentation can be found here.

What are my options for creating vertices and edges in AGE? – Postgresql

I understand there will be several ways to create vertices and edges in APACHE AGE. What are the other ways for creating except create clause?

Multiple ways to create vertices and edges in AGE

Tags:

5

Answers


  1. 0

    You can use the copy command to load data into a graph. Copy command can be used to create vertices and edges by specifying data format.
    Also try exploring MERGE clause which can be used to create edges/vertices if a certain condition is true.

    MERGE (p:Person {name: 'abcd'})
ON CREATE SET p.age = 30, p.email = '[email protected]'
RETURN p

    This checks if a vertex Person with name ‘abcd’ already exists and if not creates a new one.

    Login or Signup to reply.
  2. 0

    You can also create vertices and edges by loading data from a csv file. In the apacheAGE docs it is explained thoroughly how to load graphs,vertices and edges from a csv file and also what should the format of the csv file be.

    Login or Signup to reply.
  3. 0

    If vertices exist, you can use the MATCH clause to create edges between existing vertices. The clause can be used to find existing vertices that meet a specified condition and then create an edge between them.

    Login or Signup to reply.
  4. 0

    In Apache age there are several ways of creating vertices and edges.

    First you can use load clause to load data from csv file.

    LOAD CSV FROM 'data.csv' AS row 
CREATE (:USER {name:row[0], age:row[1]})

    Second you can use the Merge:

    MERGE (:USER {name: 'name', age:20})

    Third By using SET:

    MATCH( p:USER {name : 'name' })
SET p.age = 33
    Login or Signup to reply.
  5. 0

    There are several ways to create vertices and edges in Apache AGE apart. Here are some of them:

    1. By Importing CSV Files:

    You can use the load_labels_from_file and load_edges_from_file commands to load data from a CSV file and create vertices and edges. Refer the official Apache Age documentation for more about this.

    2. Using UNWIND:

    You can use the UNWIND command to create multiple vertices or edges at once from a list or an array. Here is an example:

    SELECT * FROM cypher('graph_name', $$ 
UNWIND ['Alice', 'Bob', 'Charlie'] AS name
CREATE (:Person {fname: name})
$$) as (fname agtype);

    3. By Using Merge Clause:

    You can use the MERGE command to create vertices or edges if they don’t already exist. If a matching vertex or edge already exists, it will be updated with the new properties. Adding to the earlier example, here’s how you can use merge:

    SELECT * FROM cypher('graph_name', $$ 
MERGE (:Person {fname: 'Bella'})
$$) as (fname agtype);
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search