After searching for a long time I found this simple 2 steps to connect to a postgres DB and hit a query and get the required data

During automation for a website we had to set a firebug and netexport profile to every new webdriver instance in firefox . We were using selenium webdriver with Ruby . There is a solution using java . We did it for ruby in following way