Contents
CREATE SEQUENCE
A DDL command to define a new sequence
CREATE SEQUENCE
is a DDL command to define a new sequence.
CREATE SEQUENCE
was added in PostgreSQL 6.4.
Change history
- PostgreSQL 10
CREATE SEQUENCE AS data_type
clause added (commit 2ea5b06c)
- PostgreSQL 8.2
CREATE SEQUENCE ... OWNED BY ...
syntax added (commit 2b2a5072)
- PostgreSQL 7.4
NO MAXVALUE
andNO MINVALUE
options added (commit f249daf9)
- PostgreSQL 7.2
- support for temporary sequences added (commit a0c12d5e)
- PostgreSQL 6.4
- added (commit 9729f6ca)
References
- PostgreSQL documentation: CREATE SEQUENCE