I have QGIS 2.8. I open up the database manager, connect to PostGIS, and then execute a query. The resulting query has an id column, a name column, a geom column, and a membership column.

I click on the button "Load as new Layer" and then the button "Load Now!" Nothing happens after that. The layer does not appear in any layer list. I have looked at the documentation and cannot see what I am doing wrong.

  • Welcome to GIS SE, can you edit your question and add an image showing the query window? – artwork21 Apr 22 '15 at 17:09

Qgis has got an informative error in the status bar for all the layers being loaded. Try to read what the error says after loading the layer. Another source of error could be that your I'd column is not unique . Test to see if it that is the case

  • 1
    I can't see any status bar at all. Nothing happens at all. The only message I see is "Table Retrieval Finished." – Paul Tremblay Apr 23 '15 at 21:09

Modify your sql query to select only the geometry column. I had same problem - I think the layer creation was failing I had 2 columns with same name, after a join. Selecting only the geom column allowed the layer to be created.

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.