Menambahkan kolom baru sebagai Primary Key ke sebuah tabel

ALTER TABLE functional ADD COLUMN id serial NOT NULL PRIMARY KEY;

atau

ALTER TABLE "public"."functional" ADD COLUMN "id" INTEGER;

CREATE SEQUENCE "public"."functional_id_seq";

UPDATE functional SET id = nextval('"public"."functional_id_seq"');

ALTER TABLE "public"."functional"

ALTER COLUMN "id" SET DEFAULT nextval('"public"."functional_id_seq"');

ALTER TABLE "public"."functional"

ALTER COLUMN "id" SET NOT NULL;

ALTER TABLE "public"."functional" ADD UNIQUE ("id");

ALTER TABLE "public"."functional" DROP CONSTRAINT "functional_id_key" RESTRICT;

ALTER TABLE "public"."functional" ADD PRIMARY KEY ("id");