Deleting duplicate records - Mailing list pgsql-general

From Bob Powell
Subject Deleting duplicate records
Date
Msg-id sed3915a.014@grpwise.hotchkiss.org
Whole thread Raw
Responses Re: Deleting duplicate records
List pgsql-general
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
theyall 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



pgsql-general by date:

Previous
From: Michael Owens
Date:
Subject: Learning: Freeing of Unused Records
Next
From: "Montervino, Mariano"
Date:
Subject: Solaris 2.8 (sparc)