Delete duplicate records from postgres table

suggest change
DELETE 
    FROM <SCHEMA_NAME>.<Table_NAME> 
WHERE 
    ctid NOT IN
        (
        SELECT 
            MAX(ctid) 
        FROM 
            <SCHEMA_NAME>.<TABLE_NAME> 
        GROUP BY 
            <SCHEMA_NAME>.<TABLE_NAME>.*
        )
;

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:



Table Of Contents