Serial data types


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


type_specification ::= SMALLSERIAL | SERIAL | BIGSERIAL


  • 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.