On Fri, Aug 3, 2012 at 7:00 PM, Matthew Foster <[email protected]>wrote:

> I have a PostGIS db data source on which I need to join in some
> denormalized tables (i.e. it would have one-to-many relationships).  If I
> want to display this source via Geoserver, am I going to have to use an
> Application Schema to handle the denormalized tables?


Application schema is to be used if you need to come out with a GML
compatible complex schema in WFS,
otherwise you are probably better off using a SQL view, and paste there the
SQL query representing the
source of your data

Cheers
Andrea


-- 
==
Our support, Your Success! Visit http://opensdi.geo-solutions.it for more
information.
==

Ing. Andrea Aime
@geowolf
Technical Lead

GeoSolutions S.A.S.
Via Poggio alle Viti 1187
55054  Massarosa (LU)
Italy
phone: +39 0584 962313
fax:   +39 0584 962313
mob:   +39  339 8844549

http://www.geo-solutions.it
http://twitter.com/geosolutions_it

-------------------------------------------------------
------------------------------------------------------------------------------
Live Security Virtual Conference
Exclusive live event will cover all the ways today's security and 
threat landscape has changed and how IT managers can respond. Discussions 
will include endpoint security, mobile security and the latest in malware 
threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
_______________________________________________
Geoserver-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-users

Reply via email to