MatheusFarias03 commented on issue #1031: URL: https://github.com/apache/age/issues/1031#issuecomment-1640667015
> Is there any table that AGE use to store node/edges different label combined? You can see which tables AGE creates by default, and all it's functions, in the [age--1.3.0.sql](https://github.com/apache/age/blob/master/age--1.3.0.sql) file. If you want to see all the available labels created for the graphs in your database, you can check the `ag_label` table for that. It's going to store all the labels, not every node or every edge all together. For that, as Zainab Saad stated, there are two parent tables: `_ag_label_vertex` and `_ag_label_edge` for the respective graph. So, to see all the labels, nodes and edges combined, execute the following query: ```sql SELECT * FROM ag_catalog.ag_label; ``` And, if you have already created a graph, it will show this: ``` name | graph | id | kind | relation | seq_name ------------------+-------+----+------+-----------------------------+------------------------- _ag_label_vertex | 18128 | 1 | v | graph_name._ag_label_vertex | _ag_label_vertex_id_seq _ag_label_edge | 18128 | 2 | e | graph_name._ag_label_edge | _ag_label_edge_id_seq (2 rows) ``` -- 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]
