pg_sequences The view pg_sequences provides access to
useful information about each sequence in the database.
Table 51.85. pg_sequences Columns
| Name | Type | References | Description |
|---|---|---|---|
schemaname | name | | Name of schema containing sequence |
sequencename | name | | Name of sequence |
sequenceowner | name | | Name of sequence's owner |
data_type | regtype | | Data type of the sequence |
start_value | bigint | Start value of the sequence | |
min_value | bigint | Minimum value of the sequence | |
max_value | bigint | Maximum value of the sequence | |
increment_by | bigint | Increment value of the sequence | |
cycle | boolean | Whether the sequence cycles | |
cache_size | bigint | Cache size of the sequence | |
last_value | bigint | 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. Null if the sequence has not been read from yet. Also, if
the current user does not have USAGE
or SELECT privilege on the sequence, the value is
null. |