https://neon.com/postgresql/tutorial/how-to-delete-duplicate-rows-in-postgresql
How to Delete Duplicate Rows in PostgreSQL
This tutorial shows you how to use various techniques: DELETE join, subquery, and immediate table to delete duplicate rows in PostgreSQL.
delete duplicate rowshow topostgresql