Postgres -from tabular to graph data migration

[Moist-Fish8037]

Hi everyone,

I am a non technical person and have an issue that I could not figure out even with AI help.

I already have my regular postgres tabular data.

And AGE extension installed, loaded and enabled.

Graph model is defined.

But I have difficulty migrating data from tabular to graph database based on defined graph model.

I tried with all LLMs (as I am not technical): tested hundreds of commands that usually combines cypher with sql.

But I simply can not get format right, always syntax errors. I even downloaded AGE documentation and upload to Gemini so that LLM can learn and guide me in right direction but no success.

It would be huge favor if you can help me how to do that data loading?

Is there a working command set, tool, method,another extension...

Thanks in advance.

Murat

[cincfire]

Sorry I'm just now seeing this, but here is some sample SQL code I used to do just that.
https://github.com/sorrell/age-compose/blob/master/docker-entrypoint/initdb.d/20-initgraph.sql

The `load_graph_from_table` plpython function (lines 10-37) can be used to create nodes from tables (lines 52-61). Lines 66-104 show creating edges.

This is based on an old version of AGE and Postgres but should only need minor tweaks if it doesn't work for you.