Is it possible to create PostgreSQL views over a table that contains raster data?
I have succeeded in creating the view but the entry in
raster_columns is not correct (all the raster info is missing). Also, I couldn't open the SQL view using QGIS (most probably because of the raster_columns not being correct).
It's the same situation as this question on gemetry_columns & views but for the raster column I couldn't find the correct syntax to force the typemod during creation of the view.
All that I could find is this:
raster(ARRAY['8BUI','8BUI','8BUI'], 4326,0.5,-0.5, ...);
but what follows after "..." is a mystery.
Has anybody managed to create a view with correct entries in raster_columns?
A short example will be highly appreciated.