Postgres 13

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t as select 1 as x union all select 1 as x

SELECT 2

alter table t add column id int generated always as identity

ALTER TABLE

select * from t

x
id

1
1

1
2

SELECT 2