--查看数据库中有哪些序列--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;
--查看数据库中有哪些序列--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;
本文标题:Postgresql查看数据库中有哪些序列
本文链接:https://www.haomeiwen.com/subject/hwlpihtx.html
网友评论