Revision history of "Postgres delete duplicates"

Jump to navigation Jump to search

Diff selection: Mark the radio boxes of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

  • curprev 23:13, 29 May 2022Busk talk contribs 284 bytes +284 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..."