PostgreSql序列查找当前值和设置id初始值


select setval('auth_user_id_seq', 100);

select nextval('auth_user_id_seq');

--查看数据库中有哪些序列
--r =普通表, i =索引,S =序列,v =视图,m =物化视图, c =复合类型,t = TOAST表,f =外部表
select *  from pg_class where relkind='S'