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.
PostgreSQL
PostgreSQL is a powerful, open source object-relational database system. It can be installed by any unprivileged user without requiring superuser access
How to copy a table PostgreSQL ?
To copy a table in PostgreSQL, you can use the CREATE TABLE statement with the AS clause. This allows you to create a new table that is a copy of an existing table. Here’s a basic example: