Difference between revisions of "Postgres delete duplicates"
Jump to navigation
Jump to search
(Created page with "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.c...") |
(No difference)
|
Latest revision as of 23:13, 29 May 2022
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