Serial data types

This page documents the preview version (v2.23). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

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.