I follow this great post:pgRouting 2.0 for Windows quick guide, and I have loaded the test data from GeoJSON, like this: enter image description here

But I don't know how to load this layer into my database, and my DB manager doesn't look the same as in Anita's post: enter image description here

How should I do to load and test this layer into my PostGIS database?

1 Answer 1


You are using QGIS 1.8, 2.0 adds the Import and Export buttons to the DB Manager plugin. Without upgrading QGIS you're going to need to use another import tool to get your data into PostGIS. You can either use ogr2ogr to directly import your GeoJSON file, or you can right click on the layer in QGIS, save it to a shapefile then use shp2PGSQL, shp2PGSQL-gui, SPIT, or any one of a number of different shapefile to PostGIS importers.

Personally I'd upgrade QGIS to 2.0, there are tons of improvements and the direct import to PostGIS from the DB Manager window is one of my favorites.

  • Thanks for your answer, I've downloaded QGIS 2.0 and I am trying its new features!
    – Heinz
    Dec 3, 2013 at 5:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.