If I recall correctly, you can export the tables that keep the relationships.
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. On Fri, Oct 24, 2014 at 11:17 AM, Randal Hale < [email protected]> wrote: > 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. > > Randy > > > > On 10/24/2014 09:14 AM, David Haynes wrote: > > 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. > > Perhaps you could explain more about the relationship classes you are > trying to implement. > > On Thu, Oct 23, 2014 at 11:32 PM, Jochen Albrecht < > [email protected]> wrote: > >> >> 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). >> 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. >> Cheers, >> Jochen >> >> _______________________________________________ >> postgis-users mailing list >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > > > _______________________________________________ > postgis-users mailing > [email protected]http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > > > -- > ----------------- > Randal Hale > North River Geographic Systems, > Inchttp://www.northrivergeographic.com423.653.3611 > [email protected] > twitter:rjhale > http://about.me/rjhalehttp://www.northrivergeographic.com/spatial-connect > > > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users > -- George R. C. Silva SIGMA Consultoria ---------------------------- http://www.consultoriasigma.com.br/
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
