agensgraph
agensgraph copied to clipboard
bitnine-oss
Can I have to migrate my PostgreSQL relational data to agansgraph or there is some other way to relate both?
Hey! I have existing table data in my local PostgreSQL, I want to use this data with my Agensgraph graph data. can I have to migrate my relational data to agensgraph or can I access that data from agensgraph too? there is some PostgreSQL extension, but I don't know what it is for and how to use it? Guide me on that ... Thanks in advance!!!
To use PostgreSql RDBMS data in graph DB, you need to convert it into JSON type data. The conversion process is not difficult. You can check the manual at the following link: https://bitnine.net/learn/
You may also refer to the link below. https://bitnine.net/tutorial/tutorial_eng.html?ckattempt=2.
Thanks for your kind response. so it means I have to convert all data to graph or JSON type? what if I want to convert some of the table data such as the id column and leave other data as relational data(id column in graph and another attribute in relational tables), can I still query all the data simultaneously( or maybe hybrid queries )? what if it's possible? so still I have to import all data to agensgraph? please guide me on that. Thanks!
On Thu, Jun 16, 2022 at 8:56 AM YoungWoo kim @.***> wrote:
To use PostgreSql RDBMS data in graph DB, you need to convert it into JSON type data. The conversion process is not difficult. You can check the manual at the following link: https://bitnine.net/learn/
— Reply to this email directly, view it on GitHub https://github.com/bitnine-oss/agensgraph/issues/564#issuecomment-1157203745, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASHXGNN5E4WA2UOKJVI3P2LVPKQXZANCNFSM5XMBGZEQ . You are receiving this because you authored the thread.Message ID: @.***>
It is not necessary to convert all data into agensgraph, i.e. graph data. Some are in the graph area, some are in the relational table, and as long as there is a key value that can connect the two data, you can query using a hybrid query.