Ubuntu manuals

Provided by: manpages-zh_1.5.2-1_all

NAME

       ALTER SEQUENCE -

SYNOPSIS

       ALTER SEQUENCE name [ INCREMENT [ BY ] increment ]
           [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
           [ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]

DESCRIPTION

       ALTER SEQUENCE   ALTER SEQUENCE

PARAMETERS

       name

       increment
              INCREMENT BY increment

       minvalue

       NO MINVALUE
                MINVALUE minvalue   NO MINVALUE  1  -2^63-1

       maxvalue

       NO MAXVALUE
                MAXVALUE maxvalue  NO MAXVALUE 2^63-1  -1

       start
                RESTART WITH start

       cache  CACHE cache  1

       CYCLE
                CYCLE  maxvalue  minvalue minvalue maxvalue

       NO CYCLE
                NO CYCLE nextval   CYCLE  NO CYCLE

EXAMPLES

         105  serial

       ALTER SEQUENCE serial RESTART WITH 105;

NOTES

        ALTER SEQUENCE

       ALTER SEQUENCE  nextval

COMPATIBILITY

   SQL99
       ALTER SEQUENCE  PostgreSQL   SQL99  ALTER SEQUENCE

       Postgresql  <laser@pgsqldb.org>