<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 http-equiv=Content-Type content="text/html; charset=iso-8859-1"><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]--></head><body lang=EN-US link="#0563C1" vlink="#954F72"><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 width=96 height=72 style='width:1.0in;height:.75in' id="Picture_x0020_1" src="cid:image001.jpg@01D5EB14.3E9A23A0" alt=earthtiny><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>