Need help to implement Primary Key.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,
I have a table with a record count of ~500 million (496,098,390). There is no primary key in this table. Now I need to set up a primary key on this table. I can't find a way to set up a primary key. I tried to add a new column with IDENTITY but it is not allowing null value for existing rows and I don't know how to update the unique value for existing records.

Please help me to implement the same.

Thanks & Regards
Gambhir Singh


[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux