Deleting duplicates from a table

PL/pgSQL

DELETE FROM tablename tbl WHERE EXISTS (SELECT 1 FROM tablename tbl1 WHERE tbl1.unique_value = tbl.unique_value AND tbl1.id > tbl.id);