How to delete duplicate rows? - Mailing list pgsql-general

From Clodoaldo Pinto
Subject How to delete duplicate rows?
Date
Msg-id a595de7a050203170413607077@mail.gmail.com
Whole thread Raw
Responses Re: How to delete duplicate rows?
Re: How to delete duplicate rows?
List pgsql-general
This one must be obvious for most here.

I have a 170 million rows table from which I want to eliminate
duplicate "would be" keys and leave only uniques.

I found a query in http://www.jlcomp.demon.co.uk/faq/duplicates.html
for the oracle database but can't figure out how to refer to the row
id in postgresql:

delete from test where rowid not in
(select min(rowid) from test group by a,b);

How to refer to the row id? Any better way to do it?

Regards, Clodoaldo Pinto

pgsql-general by date:

Previous
From: Mike Nolan
Date:
Subject: Re: Is there a peer-to-peer server solution with PG?
Next
From: David Fetter
Date:
Subject: Re: Is there a peer-to-peer server solution with PG?