qgis / QGIS

QGIS is a free, open source, cross platform (lin/win/mac) geographical information system (GIS)
https://qgis.org
GNU General Public License v2.0
10.65k stars 3.01k forks source link

Hide PostGIS raster overviews from browser panel #53829

Open effjot opened 1 year ago

effjot commented 1 year ago

Feature description

Raster overviews in PostgreSQL/PostGIS databases are regular raster tables named o_…. If you have more than a few rasters in a database schema, the browser panel view is quite cluttered. As you rarely access the raster overviews directly as an user (I don’t know if there’s even a real use case for that), it would be nice to hide those from the browser panel.

Maybe the “hide path” feature could be extended to non-file datasources, including wildcards. Even better would be to exclude any table listed in the view raster_overviews, so overviews are hidden even if they don’t use the standard name.

Thanks for considering this idea!

Additional context

No response

effjot commented 1 year ago

Probably the query in QgsPostgresConn::getTableInfo() (file qgspostgresconn.cpp) could be adapted to do this. But my C/C++ skills are very rusty.

kewgis commented 2 months ago

Could this perhaps be an option in the Browser Panel Filter?