Postgresql查看数据库中有哪些序列

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

select * from pg_class where relkind='S'

--新建序列

CREATE SEQUENCE "public"."district2_gid_seq" 
INCREMENT 1
MINVALUE  1
MAXVALUE 2147483647
START 1
CACHE 1;