1、删除主键
ALTER TABLE "table_name" DROP CONSTRAINT "table_name_pkey";
2、ALTER TABLE "table_name" add primary key (xx,xx,xx);
3、更新列数据
UPDATE "table_name" SET "table_column"=1 where "table_name" is null
1、删除主键
ALTER TABLE "table_name" DROP CONSTRAINT "table_name_pkey";
2、ALTER TABLE "table_name" add primary key (xx,xx,xx);
3、更新列数据
UPDATE "table_name" SET "table_column"=1 where "table_name" is null