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.