How do I delete duplicate rows in a table?

From: "Wang, Mary Y" <mary(dot)y(dot)wang(at)boeing(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: How do I delete duplicate rows in a table?
Date: 2010-02-08 23:32:51
Message-ID: FA20D4C4FEBFD148B1C0CB09913825FC01EBD53868@XCH-SW-06V.sw.nos.boeing.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a table that have that duplicate rows. How do I find them and delete them?

Please advise.
Mary

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Sergio Borgonovo 2010-02-08 23:40:43 Re: How do I delete duplicate rows in a table?
Previous Message Ivan Sergio Borgonovo 2010-02-08 23:05:05 Re: turning a tsvector without position in a weighted tsvector