Zainab-Saad commented on issue #1031:
URL: https://github.com/apache/age/issues/1031#issuecomment-1635436039
Have you looked into the table `graph_name._ag_label_vertex` and
`graph_name._ag_label_edge` ?
From what I understood initially is that you want to query the table that
has **all the vertices** or **all the edges**. In that case, querying the above
two tables should do the work.
For example, I have created vertices, edges as:
```
SELECT * FROM cypher('graph', $$
CREATE (n: VertexA {prop: "VertexA"})-[e1: EDGE_1 {prop: "EDGE_1"}]->(m:
VertexB {prop: "VertexB"})-[e2: EDGE_2 {prop: "EDGE_2"}]->(o: VertexC {prop:
"VertexC"})
$$) AS (result agtype);
```
The tables `graph."VertexA"`, `graph."VertexB"`, `graph."VertexC"` each
contains the individual label's vertices but the table `graph._ag_label_vertex`
contains all the vertices (because `graph._ag_label_vertex` is the default
table for storing vertices irrespective of the label)
Same is the case with edges, `graph."EDGE_1"` and `graph."EDGE_2"` contain
the edges belonging to each of these labels but the table
`graph._ag_label_edge` contains all these edges irrespective of the label they
have
P.S: `_ag_label_vertex` and `_ag_label_edge` is not associated to any label
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
