Skip to content

Instantly share code, notes, and snippets.

@mvodep

mvodep/20210422.duplicates.sql

Last active August 20, 2021 05:46
Show Gist options
  • Save mvodep/3681eb16e8793bfcc08cd8a85270cb2a to your computer and use it in GitHub Desktop.
Save mvodep/3681eb16e8793bfcc08cd8a85270cb2a to your computer and use it in GitHub Desktop.
Download ZIP
Raw
20210422.duplicates.sql
BEGIN;
LOCK TABLE new_table IN ACCESS EXCLUSIVE MODE;
CREATE TABLE new_table_clean AS
(SELECT DISTINCT ON(column1, column2) * FROM new_table);
TRUNCATE TABLE new_table;
INSERT INTO new_table SELECT * FROM new_table_clean;
END;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment