[Hibernate] Improving schemas support

[Christian Meunier]

Title: CarrierWave

Hi all,   now that postgresql support schemas, i would like to leverage this in my next project.In this project, i will have 1 to N schema(s) having the exactly same table names. What i would like to do it to be able to specify at runtime, once i open a hibernate session the schema name on which i would like to work. Such mutator could temporarly update ( for the duration of the session) the schema name specified by the root <hibernate-mapping> element.   It might be usefull too, to find a way to specify a schema name in the query language (if we want to be able to do a query working on more than one schema at a time that got the same table names)   What do you think about this ? Is hibernate already support what i would like to do ?   Thanks in advance and happy new year everyone. Christian Meunier