pg_sequences
The view pg_sequences provides access to useful information about each sequence in the database.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- schemaname, sequencename, sequenceowner, data_type, start_value, min_value, max_value, increment_by, cycle, cache_size, last_value
- runtime verified
- false
- source
- english-manual
Definition PG 18
The view pg_sequences provides access to useful information about each sequence in the database.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| schemaname | name | Nullable | Name of schema containing sequence |
| sequencename | name | Nullable | Name of sequence |
| sequenceowner | name | Nullable | Name of sequence's owner |
| data_type | regtype | Nullable | Data type of the sequence |
| start_value | int8 | Nullable | Start value of the sequence |
| min_value | int8 | Nullable | Minimum value of the sequence |
| max_value | int8 | Nullable | Maximum value of the sequence |
| increment_by | int8 | Nullable | Increment value of the sequence |
| cycle | bool | Nullable | Whether the sequence cycles |
| cache_size | int8 | Nullable | Cache size of the sequence |
| last_value | int8 | Nullable | 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. |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:0335ceb813951e41f69d59714bdd029ec8bdeedf740effa7287ebe58b0207ff6
Text language: en · catalog-bilingual-repair:0335ceb813951e41f69d59714bdd029ec8bdeedf740effa7287ebe58b0207ff6