Postgres Pro
Downloads
Home   >   mailing lists

query for non-unique values? - Mailing list pgsql-general

From Andy Kriger
Subject query for non-unique values?
Date
Msg-id OJEFIHHAALOBKKJEOMBDAELNCAAA.akriger@greaterthanone.com
Whole thread Raw
Responses Re: query for non-unique values?
List pgsql-general
Tree view 
I have a file of legacy data that has duplicate entries in a column that I'd
like to have a unique index on. How can I query to find the duplicates (so I
can determine if they can be thrown out)?

thx

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: OID order = INSERT order?
Next
From: pilsl@goldfisch.at
Date:
Subject: Re: bug(?) : order by function limit x