does someone knows a possibility to visualize in a bytea column saved photos of a postgresql database in qgis?
I would like to store pictures directly into the database, not just the link/ url.
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It only takes a minute to sign up.Sign up to join this community
It isn't directly possible in QGIS. Easiest approach would be to pass the bytea off to a web page/API that just presents the photo. Then you can create a View in PostGIS, and have a new column that has a URL pointing to the page: eg http://example.com/photo.php?id=1234, you can load the view into QGIS.