跳转到主要内容
← 目录图谱 / pg_sequences

SYSTEM VIEW · 系统视图

pg_sequences

PostgreSQL 官方文档 ↗

The view pg_sequences provides access to useful information about each sequence in the database.

首次收录 PG 10最近收录 PG 19当前字段 11
9.09.19.29.39.49.59.610111213141516171819β3

已与 PostgreSQL 18.6 实例逐字段核对 · 原始实测记录 ↗

字段结构 PostgreSQL 18

pg_sequences
字段 / COLUMN类型 / TYPE说明 / DESCRIPTION
schemaname name Name of schema containing sequence引用：pg_namespace.nspname
sequencename name Name of sequence引用：pg_class.relname
sequenceowner name Name of sequence's owner引用：pg_authid.rolname
data_type regtype Data type of the sequence引用：pg_type.oid
start_value bigint文档原写法：int8 Start value of the sequence
min_value bigint文档原写法：int8 Minimum value of the sequence
max_value bigint文档原写法：int8 Maximum value of the sequence
increment_by bigint文档原写法：int8 Increment value of the sequence
cycle boolean文档原写法：bool Whether the sequence cycles
cache_size bigint文档原写法：int8 Cache size of the sequence
last_value bigint文档原写法：int8 The last sequence value written to disk. If caching is used, this value can be greater than the last value handed out from the sequence.

标记“隐式列”的字段不包含在 SELECT * 中；部分早期统计视图由同版本源码补全，额外来源会显示在字段说明中。

字段演化矩阵

悬停查看字段类型
存在新增 / 类型或属性变化移除
字段 / COLUMN9.09.19.29.39.49.59.610111213141516171819
schemaname – – – – – – –
sequencename – – – – – – –
sequenceowner – – – – – – –
data_type – – – – – – –
start_value – – – – – – –
min_value – – – – – – –
max_value – – – – – – –
increment_by – – – – – – –
cycle – – – – – – –
cache_size – – – – – – –
last_value – – – – – – –

9.0 是收录基线；基线中已存在的字段不标记为新增。矩阵按字段名称对齐，重命名显示为旧字段移除与新字段新增。

演化时间线

相邻大版本的变化

PostgreSQL 15 ← 14

1 处字段说明更新

PostgreSQL 10 ← 9.6新增目录

+ schemaname+ sequencename+ sequenceowner+ data_type+ start_value+ min_value+ max_value+ increment_by+ cycle+ cache_size+ last_value

比较任意两个版本

选择两个版本，查看字段的新增、移除与类型变化。交互比较需要 JavaScript；演化时间线可直接阅读。