Re: [Geoserver-devel] accessing database tables

[Andrea A. <aa...@op...>]

Dave Potts ha scritto:
> I have been looking into replacing an instance of mapserver with 
> geoserver.  But to do this I need to access several different tables in 
> my database.
> 
> I have been through the source code and the on line help and there 
> does'nt seem to be a way of building a request from more than one data 
> table in a datasource, is this correct or have I missed something vitial.

There is no way to specify a SQL query in the configuratin, but you
can build a view, register it against the metadata tables of your
dbms so that it looks like a geometric table, and you're done,
you can register the view as if it was a simple table.

You're still limited to simple features thought, whatever is
the result of your view, it will be served as a flat table
(and be read only as well).

Hope this helps
Cheers
Andrea