Re: restore/dup OIDs HELP! - Mailing list pgsql-admin

Jack Flak <jack@flak.nospam.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