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

ALTER SEQUENCE

A DDL command to modify the definition of a sequence

ALTER SEQUENCE is a DDL command to modify the definition of a sequence.

ALTER SEQUENCE was added in PostgreSQL 7.4.

Change history

PostgreSQL 10
- ALTER SEQUENCE command now fully transactional (commit 3d79013b)
- ALTER SEQUENCE ... AS datatype syntax added (commit 2ea5b06c)
PostgreSQL 9.5
- ALTER SEQUENCE ... OWNER TO { CURRENT_USER | SESSION_USER } syntax added (commit 31eae602)
PostgreSQL 9.2
- ALTER SEQUENCE IF EXISTS ... syntax added (commit b8a91d9d)
PostgreSQL 8.4
- ALTER SEQUENCE ... START [ WITH ] ... syntax added (commit caede71b)
- ALTER SEQUENCE ... RESTART [ WITH ] ... syntax added (commit 10a3471b)
PostgreSQL 8.3
- ALTER SEQUENCE ... RENAME TO ... syntax added (commit a5589813)
PostgreSQL 8.2
- ALTER SEQUENCE ... OWNED BY ... syntax added (commit 2b2a5072)
PostgreSQL 8.1
- ALTER SEQUENCE ... SET SCHEMA ... syntax added (commit 35508d1c)
PostgreSQL 7.4
- added (commit 5f65225f)

References

PostgreSQL documentation: ALTER SEQUENCE

Categories

See also

CREATE SEQUENCE, DROP SEQUENCE