Serial data types
This page documents a preview version.
v2.23 Preview
Preview includes features under active development and is for development and testing only.
For production, use the latest stable version (v2024.1).
For production, use the latest stable version (v2024.1).
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.