create table t11 (id serial primary key ,name varchar(20),age int);
TEST=# insert into t11 (name,age) values(‘xxx’,33);
INSERT 0 1
TEST=# select * from t11;
id | NAME | age
----±-----±----
1 | xxx | 22
2 | xxx | 33
(2 行记录)
—修改初始值
select setval(‘table_id_seq’,1000,false);
—下一个值
select nextval(‘序列名’);
– 查询序列当前值
select currval(‘test_seq’);
##建表
create table t2 (id int ,c2 varchar(10));
##插入数据
insert into t2 values(1,1);
###取出此表自增列最大值
select max(id) from 表名
##创建序列
CREATE SEQUENCE t2_id_seq
INCREMENT BY 1
MINVALUE 1
MAXVALUE 2147483647
START WITH 1 ####改成此表自增列最大值
CACHE 1
NO CYCLE;
##修改表自增
ALTER TABLE “public”.“t2” ALTER COLUMN “id” SET DEFAULT nextval(‘t2_id_seq’::regclass);