The pg_sequence catalog provides information about sequences.
| Column name | Data type | Description |
|---|---|---|
seqrelid |
oid (references pg_class.oid) |
The OID of the pg_class entry for this sequence. |
seqtypid |
oid (references pg_type.oid) |
The data type of the sequence. |
seqstart |
int8 |
The start value of the sequence. |
seqincrement |
int8 |
The increment value of the sequence. |
seqmax |
int8 |
The maximum value of the sequence. |
seqmin |
int8 |
The minimum value of the sequence. |
seqcache |
int8 |
The cache size of the sequence. |
seqcycle |
bool |
Specifies whether the sequence cycles (TRUE) or not (FALSE). |