Get sequence next value : Sequence Value « Sequence « PostgreSQL

1. PostgreSQL
2. Sequence
3. Sequence Value

Get sequence next value

postgres=# CREATE SEQUENCE myseq MINVALUE 0;
CREATE SEQUENCE
postgres=# -- Incrementing a sequence
postgres=#
postgres=# SELECT nextval('myseq');
 nextval
---------
       0
(1 row)

postgres=#
postgres=# SELECT nextval('myseq');
 nextval
---------
       1
(1 row)

postgres=#
postgres=# drop sequence myseq;
DROP SEQUENCE
postgres=#
           
       

Related examples in the same category