↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10
Historical version. PostgreSQL 12 reached end of support in November 2024. See the current version for supported releases.
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

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.