序列使用 create table t (id serial not null,nickname text); CREATE TABLE teledb insert into t(nickname) values('seqval'); INSERT 0 1 teledb select from t; id nickname + 1 seqval (1 row) 删除序列 存在依赖对象时,无法删除,可通过cascade级联删除。 plaintext teledb drop sequence tseq; ERROR: cannot drop sequence tseq because other objects depend on it DETAIL: default for table tupdate column id depends on sequence tseq HINT: Use DROP ... CASCADE to drop the dependent objects too. teledb drop sequence tseq cascade; NOTICE: drop cascades to default for table tupdate column id DROP SEQUENCE 删除序列,不存在时跳过 plaintext teledb drop sequence if exists tseq; NOTICE: sequence "tseq" does not exist, skipping DROP SEQUENCE