<html>
<head>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
</head>
<body>
<p>Good question. <br>
</p>
<p>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. <br>
</p>
<p>Randy<br>
</p>
<div class="moz-cite-prefix">On 2/24/20 3:19 PM, Cinda Graubard
wrote:<br>
</div>
<blockquote type="cite"
cite="mid:000c01d5eb4f$b583dfc0$208b9f40$@geomax.com">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="Generator" content="Microsoft Word 15 (filtered
medium)">
<!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]-->
<style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri",sans-serif;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri",sans-serif;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="WordSection1">
<p class="MsoNormal">This may be a very naοve a question but
asking it anyway.<o:p></o:p></p>
<p class="MsoNormal">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).<o:p></o:p></p>
<p class="MsoNormal">Thanks,<o:p></o:p></p>
<p class="MsoNormal">Cinda<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">Cinda
Graubard<o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span style="color:#4F81BD">GeoMax<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">303.440.4539
office<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">720.272.9812
mobile<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><i><span style="color:#4F81BD">GIS for
Mineral Exploration<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">2D
and 3D Visualization, Integration, Analysis, Modeling<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">Project
and Data Management<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">Data
capture and conversion<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">Databases<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:9.0pt;color:gray">Software
Sales and Training <o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><img style="width:1.0in;height:.75in"
id="Picture_x0020_1"
src="cid:part1.51C1E469.170621E2@northrivergeographic.com"
alt="earthtiny" class="" width="96" height="72"><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<pre class="moz-quote-pre" wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<pre class="moz-signature" cols="72">--
Randal Hale
<a class="moz-txt-link-abbreviated" href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a>
(p) 423.653.3611
<a class="moz-txt-link-freetext" href="http://www.northrivergeographic.com">http://www.northrivergeographic.com</a></pre>
</body>
</html>