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

System Catalogs / System catalogs

pg_sequence

Read the PG 18 manual

The catalog pg_sequence contains information about sequences.

Reading PG 18current·documented in 11 of 24 versions, 10 to 20

7.4 8.0 8.1 8.2 8.3 8.4 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

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

Columns 8

As listed in the PostgreSQL 18 manual.

Column	Type	Description / reference
`seqrelid`	`oid`NOT NULL	The OID of the pg_class entry for this sequence pg_class.oid
`seqtypid`	`oid`NOT NULL	Data type of the sequence pg_type.oid
`seqstart`	`int8`NOT NULL	Start value of the sequence
`seqincrement`	`int8`NOT NULL	Increment value of the sequence
`seqmax`	`int8`NOT NULL	Maximum value of the sequence
`seqmin`	`int8`NOT NULL	Minimum value of the sequence
`seqcache`	`int8`NOT NULL	Cache size of the sequence
`seqcycle`	`bool`NOT NULL	Whether the sequence cycles

Column history across versions

seqrelid

7.4 8.0 8.1 8.2 8.3 8.4 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

seqtypid

7.4 8.0 8.1 8.2 8.3 8.4 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

seqstart

7.4 8.0 8.1 8.2 8.3 8.4 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

seqincrement

7.4 8.0 8.1 8.2 8.3 8.4 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

seqmax

7.4 8.0 8.1 8.2 8.3 8.4 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

seqmin

7.4 8.0 8.1 8.2 8.3 8.4 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

seqcache

7.4 8.0 8.1 8.2 8.3 8.4 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

seqcycle

7.4 8.0 8.1 8.2 8.3 8.4 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

Version history 2

13 → 14 reworded
9.6 → 10 added

Definition snapshot: english-manuals:87aecb8d9f1a9f194a72f6e192c… · English manual source