如何使用递增值进行更新

I have a table in PostgreSQL that has an ID column that is supposed to be unique. However, a large number of the rows (around 3 million) currently have an ID of "1".I have a table in PostgreSQL that has an ID col