PostgreSQL adding a unique GUID column

In PostgreSQL, it is easy to add a GUID column and fill it:

ALTER TABLE public."thetable" ADD aggregateid uuid DEFAULT gen_random_uuid() NOT NULL;
ALTER TABLE public."thetable" ADD CONSTRAINT thetable_unique UNIQUE (aggregateid);