PostgreSQL

PostgreSQL Elephant Logo

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

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

Copyright © 1996-2023 The PostgreSQL Global Development Group