On Oct 12, 2011, at 4:52 AM, Ben wrote: > I have a PostGIS database that has two tables. The first table contains > geometry, and the second table is connected to the first with a many to many > relationship. I would like to expose the second table to GeoServer, and I am > wondering what the best way to do this is? I was thinking of creating a view > that contains the geometry of table one, and the attributes of table two. Is > this the best solution or are there other ways to do this?
You can create a view in postgresql or use the "sql view" feature of geoserver to do a join of the two tables there. See the 2.1 docs for details. hth charles ------------------------------------------------------------------------------ All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
