51.85. pg_sequences
The view pg_sequences provides access to useful information about each sequence in the database.
Table 51.86. pg_sequences Columns
| Name | Type | References | Description |
|---|---|---|---|
schemaname | name | pg_namespace.nspname | Name of schema containing sequence |
sequencename | name | pg_class.relname | Name of sequence |
sequenceowner | name | pg_authid.rolname | Name of sequence's owner |
data_type | regtype | pg_type.oid | 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. |
© 1996–2019 The PostgreSQL Global Development Group
Licensed under the PostgreSQL License.
https://www.postgresql.org/docs/12/view-pg-sequences.html