November 21, 2024: PostgreSQL 17.2, 16.6, 15.10, 14.15, 13.18, and 12.22 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13
Development Versions: devel
Unsupported versions: 12 / 11 / 10
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
51.46. pg_sequence
Prev  Up Chapter 51. System Catalogs Home  Next

51.46. 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 51.46. pg_sequence Columns

Name Type References Description
seqrelid oid pg_class.oid The OID of the pg_class entry for this sequence
seqtypid oid pg_type.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

Prev  Up  Next
51.45. pg_seclabel  Home  51.47. pg_shdepend