remove_dublicates_postgres.sql

DELETE FROM table WHERE id IN 
                     (SELECT UNNEST(STRING_TO_ARRAY(SUBSTRING(STRING_AGG(id::varchar, ','), 
                      POSITION(',' in string_agg(id::varchar, ',')) + 1 ), ','))::integer 
                      FROM table
                      GROUP BY field1, field2, field3, field4, field5, field6
                      HAVING COUNT(*) > 1)