[Qgis-user] question about live vs linked connections

[Cinda Graubard]

Thanks! Someone independently pointed me the same way this afternoon. I’ll
test it.

Cinda

 








































Cinda Graubard

GeoMax

303.440.4539 office

720.272.9812 mobile

 

GIS for Mineral Exploration

2D and 3D Visualization, Integration, Analysis, Modeling

Project and Data Management

Data capture and conversion

Databases

Software Sales and Training 

 



 

From: Qgis-user <qgis-user-bounces at lists.osgeo.org> On Behalf Of Randal Hale
Sent: Monday, February 24, 2020 2:39 PM
To: qgis-user at lists.osgeo.org
Subject: Re: [Qgis-user] question about live vs linked connections

 

Good question. 

So There is a plugin called offline editing. You can connect to a postgis
database - sync it to be offline - edit it and sync it back to the original
table. I've not used it in production for a bit but I did a quick test
against a local database and it worked fine. I'd give that a test and see if
that would work for you. 

Randy

On 2/24/20 3:19 PM, Cinda Graubard wrote:

This may be a very naïve a question but asking it anyway.

Can one create a linked table in QGIS such that it links to a postgres db
table, but if remote it can still be opened, used and edited? Edits would
get saved back to the postgres db when not remote and likewise, changes from
the postgres db could be refreshed back to the linked table when connected.
When working with ODBC connected tables in MapInfo one has this option (live
or linked).

Thanks,

Cinda

 








































Cinda Graubard

GeoMax

303.440.4539 office

720.272.9812 mobile

 

GIS for Mineral Exploration

2D and 3D Visualization, Integration, Analysis, Modeling

Project and Data Management

Data capture and conversion

Databases

Software Sales and Training 

 



 





_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org <mailto:Qgis-user at lists.osgeo.org> 
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

-- 
Randal Hale 
rjhale at northrivergeographic.com <mailto:rjhale at northrivergeographic.com> 
(p) 423.653.3611
http://www.northrivergeographic.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200224/648222cd/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 1915 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200224/648222cd/attachment.jpg>