Busk: 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..."

2022-05-29T23:13:44Z

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..."

New page

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

Postgres delete duplicates - Revision history

Busk: 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..."