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?:
Geoserver:
SELECT source FROM pgr_nearest_node('net',%lat%,%long%)