I am working on a project that requires finding the shortest path and to achieve this, I've used the PgRouting dijkstra function and it's all worked out perfectly.
Initially, the road network was imported using an osm file. The table created consists of multilinestring geometry types.
How can I transform the multilinestring into linestring and give each of them a source id and targer id so that dijkstra function gives the shortest path starting next to the point it has localised.
Thanks all !