<div dir="ltr"><div>If I recall correctly, you can export the tables that keep the relationships.<br><br></div>If not, create a join and export only the two columns you need. For m:m relationships it's a bit nastier, and if you are using a enterprise geodatabase, with let's say, Oracle or SQL Server, you can query those, for sure.<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Fri, Oct 24, 2014 at 11:17 AM, Randal Hale <span dir="ltr"><<a href="mailto:rjhale@northrivergeographic.com" target="_blank">rjhale@northrivergeographic.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000">
QGIS gets close to replicating the ArcGIS Functionality of
relationships - but that is stored in the QGIS project and not the
data (comparable to storing the relationship class in the mxd). I
think views are the only way to do this in postgis. <br>
<br>
Randy<div><div class="h5"><br>
<br>
<br>
<div>On 10/24/2014 09:14 AM, David Haynes
wrote:<br>
</div>
<blockquote type="cite">
<div dir="ltr">The only item that immediately springs to mind
would be creating views to preserve your join relationships. Any
user that queried the view would automatically have that
underlying joined information available.
<div><br>
</div>
<div>Perhaps you could explain more about the relationship
classes you are trying to implement.</div>
</div>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Thu, Oct 23, 2014 at 11:32 PM,
Jochen Albrecht <span dir="ltr"><<a href="mailto:jochen.albrecht@gmail.com" target="_blank">jochen.albrecht@gmail.com</a>></span>
wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><br clear="all">
<div>
<div>I am working on behalf of a small non-profit that
has so far used ArcGIS but is interested in moving
open source. What kept them from making the move so
far is that they are heavy users of relationship
classes. The only discussion (inconclusive) that I
could find was initiated by Lee Hachadoorian in 2008.
Lots has changed since and I am wondering whether
anybody has actually done this (implementing
relationship classes in PostGIS). For example, back
then, Lee suggested a trial-and-error approach to
understand the encoding of relationship class tables.
Have we gotten any further on this front? I am
surprised that GIS Stack Exchange has no mentioning of
this at all (assuming the search tools work).</div>
</div>
<div>We are using relationship classes for 1:many and
many:many relationships. This is not a problem for
PostGIS; I just don't know how to migrate the
geodatabase keeping those relationships intact.</div>
<div>Cheers,</div>
<div> Jochen</div>
</div>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
postgis-users mailing list
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a></pre>
</blockquote>
<br>
</div></div><span class="HOEnZb"><font color="#888888"><pre cols="72">--
-----------------
Randal Hale
North River Geographic Systems, Inc
<a href="http://www.northrivergeographic.com" target="_blank">http://www.northrivergeographic.com</a>
<a href="tel:423.653.3611" value="+14236533611" target="_blank">423.653.3611</a> <a href="mailto:rjhale@northrivergeographic.com" target="_blank">rjhale@northrivergeographic.com</a>
twitter:rjhale <a href="http://about.me/rjhale" target="_blank">http://about.me/rjhale</a>
<a href="http://www.northrivergeographic.com/spatial-connect" target="_blank">http://www.northrivergeographic.com/spatial-connect</a></pre>
</font></span></div>
<br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br></blockquote></div><br><br clear="all"><br>-- <br><div dir="ltr">George R. C. Silva<br>SIGMA Consultoria<div>----------------------------<br><div><a href="http://www.consultoriasigma.com.br/" target="_blank">http://www.consultoriasigma.com.br/</a><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div><div style="padding:0px;margin-left:0px;margin-top:0px;overflow:hidden;word-wrap:break-word;color:black;font-size:10px;text-align:left;line-height:130%"></div></div></div></div>
</div>