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

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_sequence

Read PG 18 manual ↗

The catalog pg_sequence contains information about sequences.

Kind: System catalogs
Columns in this snapshot: 8
Definition source: English manual

Columns 8

Column	Type	Description / reference
`seqrelid`	`oid`	The OID of the pg_class entry for this sequence pg_class.oid
`seqtypid`	`oid`	Data type of the sequence pg_type.oid
`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

Column history across versions

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`seqrelid`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqtypid`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqstart`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqincrement`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqmax`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqmin`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqcache`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●
`seqcycle`	·	·	·	·	·	·	·	●	●	●	●	●	●	●	●	●	●	●

Version history 2

PG 13 → 14changed
PG 9.6 → 10added

Definition snapshot: english-manuals:55212fc7f3e47ae2838a1def92d… · English manual source