pg_sequence
The 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 52.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 |