zhangsanfeng88 发表于 2016-11-21 03:09:02

Postgresql 更改序列自增开始值 备忘

db_tst=# begin;
BEGIN
adchap_tst=# ALTER SEQUENCE fb_fy_user_id_seq RESTART WITH 7876;
ALTER SEQUENCE
db_tst=# select nextval('fb_fy_user_id_seq');
nextval
---------
7876
(1 row)
db_tst=# commit;
页: [1]
查看完整版本: Postgresql 更改序列自增开始值 备忘