pg_sequenceThe catalog pg_sequence contains information about sequences. Some of the information about sequences, such as the name and the schema, is in pg_class.
Table 51.46. pg_sequence Columns
| Name | Type | References | Description |
|---|---|---|---|
seqrelid |
oid |
|
The OID of the pg_class entry for this sequence |
seqtypid |
oid |
|
Data type of the sequence |
seqstart |
int8 |
Start value of the sequence | |
seqincrement |
int8 |
Increment value of the sequence | |
seqmax |
int8 |
Maximum value of the sequence | |
seqmin |
int8 |
Minimum value of the sequence | |
seqcache |
int8 |
Cache size of the sequence | |
seqcycle |
bool |
Whether the sequence cycles |
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.