Contents

Change history
References
Categories
See also

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 and NO 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

Categories

See also

ALTER SEQUENCE, DROP SEQUENCE, pg_sequence, pg_sequences