Replies: 1 comment
-
The lightrag_vdb_entity and lightrag_vdb_relation should contain the named entities, don't they? I haven't yet tested postgres, but the default setup produces JSON files containing this information, hence, I would expect it to be found in the corresponding postgresql tables, too. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
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