New answers tagged tools
Although the representation of the data differs between the old and new schema the data itself should be the same. This means a series of reconciliation queries will provide certainty that the migration was without error. Say you have an Orders table. The total number of Orders per year, month or day will be the same in the old and new databases. ...
I came across this site, i think it will give you some tips on possible BI tools that work well with postgres http://www.postgresonline.com/journal/archives/133-Database-Administration,-Reporting,-and-Light-application-development.html
Top 50 recent answers are included