v2025.1 STS Stable release with standard-term support v2.25 Preview Preview release - not for production v2024.2 LTS Stable release with long-term support v2024.1 STS Stable release with standard-term support v2.20 LTS Stable release with long-term support Unsupported versions

Serial data types

Synopsis

SMALLSERIAL, SERIAL, and BIGSERIAL are short notation for sequences of SMALLINT, INTEGER, and BIGINT, respectively.

Description

type_specification ::= SMALLSERIAL | SERIAL | BIGSERIAL

Notes

  • Columns of serial types are auto-incremented.
  • SERIAL does not imply that an index is created on the column.
  • Serial types are sequences under the hood, and its values can be cached on the YB-TServer using the ysql_sequence_cache_method flag. For more information, see nextval.