The pg_sequences view provides access to information about each sequence in the database.
Overview
The pg_sequences view contains the following columns:
Column name | Type | Description |
schemaname | name | The schema name of the sequence. |
sequencename | name | The name of the sequence. |
sequenceowner | name | The name of the owner of the sequence. |
data_type | regtype | The data type of the sequence. |
start_value | int8 | The start value of the sequence. |
min_value | int8 | The minimum value of the sequence. |
max_value | int8 | The maximum value of the sequence. |
increment_by | int8 | The increment value of the sequence. |
cycle | bool | Whether the sequence cycles. |
cache_size | int8 | The cache size of the sequence. |
last_value | int8 | The last sequence value that is written to disk. If caching is used, this value can be greater than the last value extracted from the sequence. The value is empty if the sequence has not been read. In addition, if the current user does not have |