The QGIS table browser has a well-hidden option that you need to toggle to tell it what column to use as a unique key before it will let you display a view.
Making spatial view in PostGIS and adding it as layer in QGIS?Making spatial view in PostGIS and adding it as layer in QGIS?
Which means, also, your view has to include a unique column to use as a key.
