How to add ‘serial’ to existing column in PostgreSQL ?

How to add 'serial' to existing column in PostgreSQL ?

If you want to convert a normal column to a serial column in PostgreSQL, you can follow these general steps. Keep in mind that this process involves creating a new serial column, copying data, and dropping the old column.

Read more