Hi, I was unable to find a way to upload raster data to a PostGis DB from QGIS.
I was aware of the raster2pgsql tool, but for the user-cases in my projects, it is not an acceptable alternative (users do not have cli or programming skills). So, to temporally workaround this shortcoming, I decided to implement a QGIS plugin to act as a GUI to the raster2pgsql program. I have a working prototype available at https://bitbucket.org/danielluehr/rastertopgsql/overview Please, note that it is the result of just a couple of days' work, and it is my first attempt at writing a QGIS plugin. It is just a quick&dirty implementation that is far from being complete or foolproof. My goal was to call the raster2pgsql program and pipe the output to the DB directly, but I still don't know what is the best approach to send data to an established connection (or maybe open one at that moment). So, currently, the plugin just calls raster2pgsql on a file (with user specified options from the plugin GUI) and saves the results to a SQL file to be "manually" injected on the database (using some DB-manager GUI, for instance). I think a good alternative would be to incorporate it as a sub-plugin in the dbmanager plugin. I have briefly tested the plugin only against QGIS 2.8.9 and PostGIS/raster2pgsql 2.1.4 which is my target environment. Any comments, suggestions, contributions are welcome. I used plugin-builder and I think it has the minimal requirements to be uploaded to the plugin repository (at least, as an experimental plugin), but I would prefer to have some feedback before uploading it there. Regards -- Daniel Vicente Lühr Sierra IEEE Member IEEE Student Branch Counselor - Universidad Austral de Chile _______________________________________________ Qgis-developer mailing list Qgis-developer@lists.osgeo.org List info: http://lists.osgeo.org/mailman/listinfo/qgis-developer Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-developer