Deleting duplicate records

Поиск
Список
Период
Сортировка
От Bob Powell
Тема Deleting duplicate records
Дата
Msg-id sed3915a.014@grpwise.hotchkiss.org
обсуждение исходный текст
Ответы Re: Deleting duplicate records  (Dmitry Tkach <dmitry@openratings.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Owens
Дата:
Сообщение: Learning: Freeing of Unused Records
Следующее
От: "Montervino, Mariano"
Дата:
Сообщение: Solaris 2.8 (sparc)