Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

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