Tag: postgresql

SQL: One of the most valuable skills – Craig Kerstiens

I admit it. I suffered from an “algebra narcoleptic syndrome” during my relational database lessons at University (1996 circa). Ok it is

Sometimes you need to remove nasty duplicate on a table, based on a subset of the column. On every big database there

After a bit of work, I have managed to optimize the performance of my Postgresql Server. I have spent a saturday morning

Sometimes I need to build a small script to delete a huge set of tables of a schema. In Oracle is easy

Biblio wolf has been installed in a production environment.