目录

pg_sequences

提供序列人类可读信息的视图

pg_sequences 是一个 系统目录 视图，提供关于序列的人类可读信息。它基于底层的 系统目录 表 pg_sequence。

pg_sequences 在 PostgreSQL 10 中引入。

备注

pg_sequences 返回的一些列名与 PostgreSQL 10 之前的 序列关系 中包含的列名相匹配。有关更多信息，请参阅 pg_sequence。

按 PostgreSQL 版本定义

pg_sequences (PostgreSQL 19)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 18)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 17)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 16)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 15)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 14)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 13)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 12)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 11)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

pg_sequences (PostgreSQL 10)

              View "pg_catalog.pg_sequences"
    Column     |  Type   | Collation | Nullable | Default 
---------------+---------+-----------+----------+---------
 schemaname    | name    |           |          | 
 sequencename  | name    |           |          | 
 sequenceowner | name    |           |          | 
 data_type     | regtype |           |          | 
 start_value   | bigint  |           |          | 
 min_value     | bigint  |           |          | 
 max_value     | bigint  |           |          | 
 increment_by  | bigint  |           |          | 
 cycle         | boolean |           |          | 
 cache_size    | bigint  |           |          | 
 last_value    | bigint  |           |          |

文档：pg_sequences

变更历史

自 PostgreSQL 10 引入以来，此视图未被修改。

示例

postgres=# CREATE SEQUENCE foo_seq;
CREATE SEQUENCE

postgres=# SELECT * FROM pg_sequences WHERE sequencename='foo_seq';
-[ RECORD 1 ]-+--------------------
schemaname    | public
sequencename  | foo_seq
sequenceowner | postgres
data_type     | bigint
start_value   | 1
min_value     | 1
max_value     | 9223372036854775807
increment_by  | 1
cycle         | f
cache_size    | 1
last_value    |

分类

DDL, 序列, 系统目录

另请参阅

pg_sequence, CREATE SEQUENCE, pg_get_serial_sequence()

反馈

请在此处提交任何关于 "pg_sequences" 的评论、建议或更正 这里。