-----
     101</PRE
><P>
  </P
><P
>   Select the next number from this sequence:
</P><PRE
CLASS="PROGRAMLISTING"
>SELECT nextval('serial');

 nextval
---------
     102</PRE
><P>
  </P
><P
>   Use this sequence in an <TT
CLASS="COMMAND"
>INSERT</TT
> command:
</P><PRE
CLASS="PROGRAMLISTING"
>INSERT INTO distributors VALUES (nextval('serial'), 'nothing');</PRE
><P>
  </P
><P
>   Update the sequence value after a <TT
CLASS="COMMAND"
>COPY FROM</TT
>:
</P><PRE
CLASS="PROGRAMLISTING"
>BEGIN;
COPY distributors 