pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / A

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

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

ALTER 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

Categories

See also