<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Consolas",serif;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>Thanks! Someone independently pointed me the same way this afternoon. I’ll test it.<o:p></o:p></p><p class=MsoNormal>Cinda<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><div><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 width=96 height=72 style='width:1.0in;height:.75in' id="_x0000_i1026" src="cid:image001.jpg@01D5EB29.5457E2D0" alt=earthtiny><o:p></o:p></p></div><p class=MsoNormal><o:p> </o:p></p><div><div style='border:none;border-top:solid #E1E1E1 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b>From:</b> Qgis-user <qgis-user-bounces@lists.osgeo.org> <b>On Behalf Of </b>Randal Hale<br><b>Sent:</b> Monday, February 24, 2020 2:39 PM<br><b>To:</b> qgis-user@lists.osgeo.org<br><b>Subject:</b> Re: [Qgis-user] question about live vs linked connections<o:p></o:p></p></div></div><p class=MsoNormal><o:p> </o:p></p><p>Good question. <o:p></o:p></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. <o:p></o:p></p><p>Randy<o:p></o:p></p><div><p class=MsoNormal>On 2/24/20 3:19 PM, Cinda Graubard wrote:<o:p></o:p></p></div><blockquote style='margin-top:5.0pt;margin-bottom:5.0pt'><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'>…………………………………………………………………………………………………</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>Cinda Graubard</span><o:p></o:p></p><p class=MsoNormal><b><i><span style='color:#4F81BD'>GeoMax</span></i></b><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>303.440.4539 office</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>720.272.9812 mobile</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'> </span><o:p></o:p></p><p class=MsoNormal><b><i><span style='color:#4F81BD'>GIS for Mineral Exploration</span></i></b><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>2D and 3D Visualization, Integration, Analysis, Modeling</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>Project and Data Management</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>Data capture and conversion</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>Databases</span><o:p></o:p></p><p class=MsoNormal><span style='font-size:9.0pt;color:gray'>Software Sales and Training </span><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><img width=96 height=72 style='width:1.0in;height:.75in' id="Picture_x0020_1" src="cid:image001.jpg@01D5EB29.5457E2D0" alt=earthtiny><o:p></o:p></p><p class=MsoNormal> <o:p></o:p></p><p class=MsoNormal><br><br><o:p></o:p></p><pre>_______________________________________________<o:p></o:p></pre><pre>Qgis-user mailing list<o:p></o:p></pre><pre><a href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><o:p></o:p></pre><pre>List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre><pre>Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><o:p></o:p></pre></blockquote><pre>-- <o:p></o:p></pre><pre>Randal Hale <o:p></o:p></pre><pre><a href="mailto:rjhale@northrivergeographic.com">rjhale@northrivergeographic.com</a><o:p></o:p></pre><pre>(p) 423.653.3611<o:p></o:p></pre><pre><a href="http://www.northrivergeographic.com">http://www.northrivergeographic.com</a><o:p></o:p></pre></div></body></html>