PG_SEQUENCES¶
PG_SEQUENCES displays the sequence attributes on which the current user has permissions. This view is supported only by clusters of version 9.1.0 or later.
Column | Type | Description |
|---|---|---|
schemaname | Name | Name of the namespace. |
sequencename | Name | Name of the sequence |
sequenceowner | Name | Owner of the sequence |
start_value | Bigint | Start value of the sequence. |
min_value | Bigint | Minimum value generated by the sequence. |
max_value | Bigint | Maximum value generated by the sequence. |
increment_by | Bigint | Amount by which the generated value increases each time in a sequence. |
cycle | Boolean | If set to true, the sequence value restarts from the minimum value after reaching the maximum value. If set to false, the sequence value stops generating after reaching the maximum value. |
cache_size | Bigint | Size of the sequence cache value. |
last_value | Bigint | Most recently generated value of the sequence. |