Jack Flak <jack(at)flak(dot)nospam(dot)org> writes:
> So, once again, here's my question: how do I go about deleting the
> duplicate entries WITHOUT also deleting the originals?
Perhaps something like
CREATE TABLE foo AS SELECT DISTINCT * FROM original;
then delete all from original, then INSERT INTO original SELECT * FROM foo;
regards, tom lane