"deptno","dname","loc"是我的三个列名,各位根据自己实际情况修改。
由于uuid_generate_v1()直接生成uuid会有短横线,本人实际开发要替换掉 ‘-’
所以语句如下:
INSERT INTO "schema"."tablename"("deptno","dname","loc")
VALUES ( replace(uuid_generate_v1()::text,'-',''),NULL,NULL)
"deptno","dname","loc"是我的三个列名,各位根据自己实际情况修改。
由于uuid_generate_v1()直接生成uuid会有短横线,本人实际开发要替换掉 ‘-’
所以语句如下:
INSERT INTO "schema"."tablename"("deptno","dname","loc")
VALUES ( replace(uuid_generate_v1()::text,'-',''),NULL,NULL)