Postgres Pro
Downloads
Home   >   mailing lists

remote duplicate rows - Mailing list pgsql-general

From Junkone
Subject remote duplicate rows
Date
Msg-id 1158187617.910804.326770@i42g2000cwa.googlegroups.com
Whole thread Raw
Responses Re: remote duplicate rows  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Simon_Kelly@moh.govt.nz
Date:
Subject: Re: Issue with order by for type varchar
Next
From: "David Link"
Date:
Subject: oracle listener intercept