Finding (and deleting) dupes in relation table

From: CSN <cool_screen_name90001(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Finding (and deleting) dupes in relation table
Date: 2005-09-22 21:56:32
Message-ID: 20050922215632.51749.qmail@web52901.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a table that relates id's of two other tables:

table1id, table2id

Dupes have found their way into it (create unique
index across both fields fails). Is there a quick and
easy way to find and delete the dupes (there are tens
of thousands of records)?

Thanks,
CSN


__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-09-22 22:04:55 Re: Lines of code in PG 8.0 & 8.1?
Previous Message Hannes Dorbath 2005-09-22 21:54:52 Re: connecting windows xp to remote server