I have many tables (about 1000) in a postgis which are seperated in four different schemas. I know that every PostGIS store must be connected with just one schema. Thus, what is the most efficient way to publish these tables from different schemas on GeoServer ?
Is it a good practice to create four PostGIS stores with the same user/password but with different schema or have I to use PostGIS JNDI connection ? Is there another way to go ?