Delete duplicate records with same fields

From: Arun P(dot)L <arunpl(at)hotmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Delete duplicate records with same fields
Date: 2013-08-29 11:39:02
Message-ID: SNT148-W212FE4226B3820F811E326DB340@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi all,
Is there any way to delete duplicate rows in psql with no unique fields? I have a set of old records with their duplicates in my db and they are all having the same fields. How can I delete duplicates? Thanks in Advance,Arun

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hariraman Jayaraj 2013-08-29 12:15:50 Re: Delete duplicate records with same fields
Previous Message Tatsuo Ishii 2013-08-29 07:44:57 hot_standby_feedback