Re: remote duplicate rows - Mailing list pgsql-general

junkone1@gmail.com wrote:
> 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.

Make a new table (with a primary key) and the same columns in order,
and do: INSERT INTO newtable SELECT DISTINCT * FROM oldtable;