Hmm, for that to work the schema would need to be detected from the store and then injected into the SQL, since when on PG the schema is required. You do not have access to PG and can't create the views on the database end of things? From my understanding this is preferable in terms of performance but perhaps you do not own the database. Vee
On Thu, Jul 2, 2020 at 5:40 AM Alexandre Gacon <alexandre.ga...@gmail.com> wrote: > Hi, > > I am using env parametrization on my geoserver instance to configure a PG > datasource. > > The data I would like to publish are not in the public schema. > > I would like to be able to build SQL view layers from my tables but it > only works if I explicitly use the name of my schema, even if I have > declared it in the datasource configuration. > > It would be great to either be able to use catalog parameters in the SQL > view or that the SQL evaluation takes into account the schema defined in > the datasource. > > -- > Alexandre Gacon > _______________________________________________ > Geoserver-users mailing list > > Please make sure you read the following two resources before posting to > this list: > - Earning your support instead of buying it, but Ian Turton: > http://www.ianturton.com/talks/foss4g.html#/ > - The GeoServer user list posting guidelines: > http://geoserver.org/comm/userlist-guidelines.html > > If you want to request a feature or an improvement, also see this: > https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer > > > Geoserver-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geoserver-users >
_______________________________________________ Geoserver-users mailing list Please make sure you read the following two resources before posting to this list: - Earning your support instead of buying it, but Ian Turton: http://www.ianturton.com/talks/foss4g.html#/ - The GeoServer user list posting guidelines: http://geoserver.org/comm/userlist-guidelines.html If you want to request a feature or an improvement, also see this: https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer Geoserver-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geoserver-users
