Delete duplicate rows (PostgreSQL)

duplicates.sql

-- Works OK in PostgreSQL 9.3
DELETE FROM table_name
  WHERE ctid NOT IN
    (SELECT MAX(ctid)
      FROM
        table_name t
      GROUP BY
        t.column_1, t.column_2; -- t.* for completely duplicate rows