Re: [ADMIN] restore/dup OIDs HELP!

[Tom Lane]

Jack Flak <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster