I have a table with two columns (id, names).
At this time there is no index, because i have not needed any one.
There are about 120 million rows. Now I want to delete all duplicate rows.
I thought I could just create a unique index and postgresql qould do the
rest. But ok. Maybe postgresql didn't know which rows to delete.
Is there a query that will delete all rows where the same name is more than
one time in the table?
I only want to have every name once in the table.
My method to write a programm, select every row and cvompare it to the
others would be very slow.
There is something with a having statement, but I don't get the clue to
build that statement.
Can you help me?
Thank you very much,
pgsql-novice by date
|Next:||From: Oliver Elphick||Date: 2005-11-27 22:24:38|
|Subject: Re: could not create unique index, table contains|
|Previous:||From: Andreas Kretschmer||Date: 2005-11-27 07:03:19|
|Subject: Re: MSSQL migration questions|