CREATE SEQUENCE crm_seq01 cache 100;
CREATE TABLE crms02
(
id int not null default nextval('crm_seq01'),
name text
);
insert into crms02(name) values ('crm-test');
select * from crms02;
(2) 修改序列
将序列和一个表的指定字段进行关联,在删除那个字段或其所在表,会自动删除已关联的序列。
ALTER SEQUENCE crm_seq01 OWNED BY crms02.id;
(3) 修改序列值
ALTER SEQUENCE crm_seq01 cache 100000;
(4) 查询序列
\ds
SELECT * FROM pg_sequences;
(5) 删除序列
drop SEQUENCE crm_seq01;
drop SEQUENCE crm_seq01 cascade; -- 删除有关联的序列