You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
However, I am trying to validate my understanding, and ensure that I have everything setup correctly by digging deeper into the PostgreSQL tables.
I see that the chunk_entity_relation graph or namespace is created when I run:
SELECT * FROM ag_catalog.ag_graph;
When I run: SELECT * FROM pg_tables WHERE schemaname = 'public' AND tablename LIKE 'lightrag_%'
I see that it created the following tables:
lightrag_doc_chunks lightrag_doc_full lightrag_doc_status lightrag_llm_cache lightrag_vdb_entity lightrag_vdb_relation
I have some python code that supposed to display the graph. However, it is displaying IDs, which is not very friendly. I want to display the node's name, title, or label. When I run the query:
SELECT * FROM cypher('chunk_entity_relation', $$ MATCH (n) RETURN id(n) AS id, labels(n) AS labels, properties(n) AS props $$) AS (id agtype, labels agtype, props agtype);
I see that I have the following properties: node_id, source_id, description, entity_type, but I do not have a property such as name, or title. Am I missing something? How can I display the name of the character on the graph instead of node ID?
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
I have read some basic online articles and tutorials, but I still have some questions:
I've setup a PostgreSQL database, with the age and vector extension running. I've followed the example (https://github.com/HKUDS/LightRAG/blob/main/examples/lightrag_zhipu_postgres_demo.py), and able to use LightRAG to answer some questions.
However, I am trying to validate my understanding, and ensure that I have everything setup correctly by digging deeper into the PostgreSQL tables.
I see that the chunk_entity_relation graph or namespace is created when I run:
SELECT * FROM ag_catalog.ag_graph;
When I run:
SELECT * FROM pg_tables WHERE schemaname = 'public' AND tablename LIKE 'lightrag_%'
I see that it created the following tables:
lightrag_doc_chunks lightrag_doc_full lightrag_doc_status lightrag_llm_cache lightrag_vdb_entity lightrag_vdb_relation
I have some python code that supposed to display the graph. However, it is displaying IDs, which is not very friendly. I want to display the node's name, title, or label. When I run the query:
SELECT * FROM cypher('chunk_entity_relation', $$ MATCH (n) RETURN id(n) AS id, labels(n) AS labels, properties(n) AS props $$) AS (id agtype, labels agtype, props agtype);
I see that I have the following properties: node_id, source_id, description, entity_type, but I do not have a property such as name, or title. Am I missing something? How can I display the name of the character on the graph instead of node ID?
Thank you!
Khai
Beta Was this translation helpful? Give feedback.
All reactions