新建一张表,其中一个属性名为UID,设置其为主键自增并不允许重复。
create table autotest_schema.table_test
(
UID int not null
);
create unique index table_test_UID_uindex
on autotest_schema.table_test (UID);
alter table autotest_schema.table_test
add constraint table_test_pk
primary key (UID);
新建一个序列:
CREATE SEQUENCE autotest_schema.table_test_uid_seq
START WITH 100000
INCREMENT BY 1
MINVALUE 100000
MAXVALUE 9999999999
CACHE 1;
然后手动将序列设置为UID的默认值
如果在某个schema下注意将schema的名字写在表名和序列名前
alter table autotest_schema.table_test alter column uid set default nextval('autotest_schema.table_test_uid_seq');
网友评论