I have a database in Postgresql, which was migrated from SQL Server (only data).
On SQL Server, a table from this database has these columns:
measure_id datum measure
measure_id is auto-incremental primary key,
datum is datetime and
measure is float.
After migration in Postrgresql,
measure_id is column of type bigint.
How can I change this column (
measure_id) to bigserial and assign it as primary key, now that my table is full of data?