19.12.2012 | Hans-Jürgen SchönigRemoving duplicates in PostgreSQL
Today somebody asked me how to remove duplicates which accidentally made it into a table. The problem is: A normal DELETE won’t do, because you would delete both values – not just the one which is in there twice. To solve the problem, you have to use a “secret” column called “ctid”. The “ctid” identifies […]
Read more