SYSTEM CATALOGS / SYSTEM VIEWS
pg_sequences
Read PG 18 manual ↗The view pg_sequences provides access to useful information about each sequence in the database.
- Kind
- System views
- Columns in this snapshot
- 11
- Definition source
- English manual
Columns 11
| Column | Type | Description / reference |
|---|---|---|
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 | int8 | Start value of the sequence |
min_value | int8 | Minimum value of the sequence |
max_value | int8 | Maximum value of the sequence |
increment_by | int8 | Increment value of the sequence |
cycle | bool | Whether the sequence cycles |
cache_size | int8 | Cache size of the sequence |
last_value | 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. |
Column history across versions
| Column | 9.0 | 9.1 | 9.2 | 9.3 | 9.4 | 9.5 | 9.6 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
schemaname | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
sequencename | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
sequenceowner | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
data_type | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
start_value | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
min_value | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
max_value | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
increment_by | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
cycle | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
cache_size | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
last_value | · | · | · | · | · | · | · | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● | ● |
Version history 2
- PG 14 → 15changed
- PG 9.6 → 10added
Definition snapshot: english-manuals:da0073a46a1ffd8fbb090318b51… · English manual source