Monthly Archives: August 2013

checking which columns are never used in a oracle database

I am currently converting an Oracle database to Postgis. Instead of blindingly copying the data model, I am also checking which columns are actually really used, and drop those that are never used. In most tables it is pretty easy, I can do a quick visual check and then count that one column that seems […]