When I link my postgres/gis table to QGIS I expect to be able to add the table into QGIS. But for some reason QGIS does not recognize my tables as geometry tables. The datasets were originally shapefiles. After uploading them with the shapefile uploader of postgis they do have a geom column.
When I uploaded them I did have to change UTF 8 to LATIN1. Postgis is enabled in my database.
I would like to know why it is not working, I don't know where to start. Can anybody help me out here?
On advise of a comment I have added the result of the geom column when doing \d tablename in the psql shell.
geom | brondata.geometry(MultiPolygon,28992) |
"wijk_2014_pkey" PRIMARY KEY, btree (gid)
"wijk_2014_geom_idx" gist (geom)