How to idenity duplicate rows

From: "David Inglis" <david(dot)inglis(at)ideloveto(dot)com(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: How to idenity duplicate rows
Date: 2006-03-19 21:14:05
Message-ID: NGBBJEEGHJFPKHBHCKBDKECPCDAA.david.inglis@ideloveto.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Can anybody assist with this problem I have a table that has some duplicated
rows of data, I want to place a unique constraint on the columns userid
and procno to eliminate this problem in the future but how do I identify and
get rid of the existing duplication.

Thanks in advance

Regards

David Inglis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bob Pawley 2006-03-19 21:23:47 Connecting
Previous Message Brent Wood 2006-03-19 20:39:10 Re: OpenSuse10.0 and postgresql