| From: | Markus Bertheau <twanger(at)bluetwanger(dot)de> |
|---|---|
| To: | "Peter T(dot) Brown" <peter(at)memeticsystems(dot)com> |
| Cc: | postgres sql list <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: contracting tables |
| Date: | 2001-11-30 07:53:28 |
| Message-ID: | 1007106809.1107.11.camel@entwicklung01.cenes.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Fri, 2001-11-30 at 00:50, Peter T. Brown wrote:
> I have a table with many records, some of which are duplicates (there is no
> unique constraints). How can I contract this table to remove any of these
> duplicate records? Like when using GROUP BY in a select statement, except
> that I want to just remove the extra entries from this table directly... Any
> ideas?
If I understood you right, one problem is to identify only one row of a
duplicate. There is a 'hidden' field oid in every table that is unique.
It goes like this:
select oid, * from <yourtable>
So you could delete the rows by oid:
delete from <yourtable> where oid = <oid>
HTH
Markus Bertheau
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2001-11-30 08:51:59 | Re: contracting tables |
| Previous Message | Christopher Kings-Lynne | 2001-11-30 03:37:28 | Re: Selecting from a dynamic name |