Hello everyone:
Can someone tell me if there is a way to delete duplicate records from a table in Postgres.
I once used a database management system that had a "Delete Duplicates" which would check every field in the row and if they all matched would delete the row. You could also designate the fields you wanted the command to use to check for dups. Very nice feature. Maybe something for the TODO list?
Bob Powell