52.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 52.46. pg_sequence Columns

NameTypeReferencesDescription
seqrelidoidpg_class.oidThe OID of the pg_class entry for this sequence
seqtypidoidpg_type.oidData type of the sequence
seqstartint8 Start value of the sequence
seqincrementint8 Increment value of the sequence
seqmaxint8 Maximum value of the sequence
seqminint8 Minimum value of the sequence
seqcacheint8 Cache size of the sequence
seqcyclebool Whether the sequence cycles