As a example, if I check the option Also list tables with no geometry on the Add SpatiaLite layer(s) dialog, it's possible to add to the project a table with a geometry column as a table with no geometry:
Is it possible to do the same thing with PostGIS? (I'm using QGIS 2.18.8)