June 23rd, 2009 by depesz | Tags: , , , , | Comments Off on Tips N’ Tricks – Generating readable reports with plain SQL

Let's say you imported some data, but it contains duplicates. You will have to handle them in some way, but to make sensible choice on how to handle it, you need more information. So, let's start. We have table: # \d users ...

Today, on #postgresql on IRC, guy (can't contact him now to get his permission to name him), said: I have a table called problematic_hostnames. It contains a list of banned hostnames in column "hostname" (varchar). I would like to display the ...