Hello,
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,
Christian