I have multiple kind of environment on which my application runs like Test environment or prod environment.I have different configuration files for each environment named application-prod.properties and application-test.properties and all other common but necessary properties are saved in application.properties file.Here application.properties file is overridden by respective environment properties file thus getting the desired environment variables at runtime.
I want to store these environment specific variables in Postgresql database so that at runtime I could retrieve those variables based on the environment the application is running.
Can anyone help me to achieve this goal ? How should I design this database for storing environment variables ?