I would like a suggestion for me to try to solve a problem that a few days
ago.
My GeoServer is connected to a PostGIS database. How can I generate a layer
from a query (sql) generated in a PHP page (thus out of GeoServer)? Ie how
to send query via Post to GeoServer? Thanks
Have a look at CQL_FILTER for a light weight solution. If not you are going to have to use the REST API to configure a virtual table (i.e. ask geoserver to publish the result of an SQL statement).
I will point out that GeoServer (as a middleware application) is trying to avoid the use of SQL and make use of an appropriate standard for requests. Not all data sources speak SQL
–
Jody Garnett
On Thursday, 20 June 2013 at 11:56 AM, Marcio William wrote:
I would like a suggestion for me to try to solve a problem that a few days
ago.
My GeoServer is connected to a PostGIS database. How can I generate a layer
from a query (sql) generated in a PHP page (thus out of GeoServer)? Ie how
to send query via Post to GeoServer? Thanks