I know how to connect Geoserver to PostgreSql and create SQL View queries with parameters from Geoserver, but ;it is possible to create a new table into PostgreSql from a Geoserver Sql View with parameters like this?:


SELECT source FROM pgr_nearest_node('net',%lat%,%long%)
  • Why would you not do this directly in Postgres? – John Powell Mar 12 '15 at 19:25
  • Hello John. Thanks for your comment. From Postgres,how it would be possible? . I would like to use Php to do some queries over the Geoserver Sql view WMS layer generated, therefore this layer should be into PostgreSql Data Base like a Table but i don't know if that depends on Geoserver or PostgreSql configuration. – user19566 Mar 13 '15 at 8:06

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.