GaussDB-MY_SEQUENCES
MY_SEQUENCES displays the sequence information about the current user. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| sequence_owner | name | Owner of a sequence. |
| sequence_name | name | Name of a sequence. |
| min_value | int16 | Minimum value of a sequence. |
| max_value | int16 | Maximum value of a sequence. |
| increment_by | int16 | Value by which the sequence is incremented. |
| cycle_flag | character(1) | Specifies whether a sequence is a cycle sequence. The value can be Y or N.- Y: It is a cycle sequence. |
- N: It is not a cycle sequence. | | order_flag | character varying(1) | Specifies whether a sequence occurs in a request sequence. This parameter is not supported. Set it to NULL. | | cache_size | int16 | Size of the sequence disk cache. | | last_number | int16 | Value of the previous sequence. | | scale_flag | character varying(1) | Specifies whether a sequence is a scalable sequence. This parameter is not supported. Set it to NULL. | | extend_flag | character varying(1) | Specifies whether the value generated by a scalable sequence exceeds the maximum or minimum value of the sequence. Not supported. Set it to NULL. | | sharded_flag | character varying(1) | Specifies whether a sequence is a shard sequence. Not supported. Set it to NULL. | | session_flag | character varying(1) | Specifies whether a sequence has a private session. This parameter is not supported. Set it to NULL. | | keep_value | character varying(1) | Specifies whether to retain the sequence value during replay after a failure. Not supported. Set it to NULL. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
