Postgres delete duplicates
Jump to navigation
Jump to search
Delete duplicates without unique column
SELECT * FROM dbversion T1 , dbversion T2 WHERE T1.ctid < T2.ctid; DELETE FROM dbversion T1 USING dbversion T2 WHERE T1.ctid < T2.ctid;
https://stackoverflow.com/questions/26769454/how-to-delete-duplicate-rows-without-unique-identifier