remote duplicate rows

From: "Junkone" <junkone1(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: remote duplicate rows
Date: 2006-09-13 22:46:58
Message-ID: 1158187617.910804.326770@i42g2000cwa.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hI
i have a bad situation that i did not have primary key. so i have a
table like this
colname1 colname2
1 apple
1 apple
2 orange
2 orange

It is a very large table. how do i remove the duplctes quickly annd
without much change.

Regards

Seede

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Don Parris 2006-09-13 23:27:09 Re: [GENERAL] Question About Aggregate Functions
Previous Message Steve Crawford 2006-09-13 21:50:16 Re: Kill specific connection