52.47. 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.47. pg_sequence Columns

   Column Type

   Description

   seqrelid oid (references pg_class.oid)

   The OID of the pg_class entry for this sequence

   seqtypid oid (references 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