2

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.

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

2 Answers 2

Reset to default
1

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

Improve this answer
1
  • 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, 2015 at 21:09
0

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.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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