I have a PostGIS database with which I am currently using QGIS to manage the layers. Say I have a layer in PostGIS that I want to do a join to to add new data in. Is it possible to do this join in-situ without having to download the layer locally, do the join and re-upload the layer, overwriting the previous one?
If this isn't possible, is the best alternative to write a script to handle the downloading, joining and re-uploading all together?