PostgreSQLでのシーケンスの作成、変更、削除

#      
CREATE SEQUENCE xxx_no_seql INCREMENT BY 1 maxvalue 99999999 START 10000000;
#     20000001            
SELECT setval('xxx_no_seql',20000001);
alter sequence xxx_no_seql restart with 20000001
#  
SELECT nextval('xxx_no_seql');
#   r =   ， i =  ，S =  ，v =  ，m =    ， c =    ，t = TOAST ，f =   
select * from pg_class where relkind='S';
#  
drop sequence xxx_no_seql;

  					  
currval(regclass)	        nextval           
nextval(regclass)	         
setval(regclass, bigint)	         
setval(regclass, bigint, boolean)	            is_called   

詳細パラメータの使用https://www.cnblogs.com/erxiaoouba/p/9075592.html