Contents
ALTER INDEX
A DDL command for modifying an index
ALTER INDEX is a DDL command for modifying an index.
ALTER INDEX was added in PostgreSQL 8.0.
Change history
- PostgreSQL 14
ALTER INDEX ... ALTER COLLATION ...syntax added (commit 257836a7)
- PostgreSQL 13
NO DEPENDS ON EXTENSIONsyntax added (commit 5fc70394)
- PostgreSQL 11
- PostgreSQL 9.6
DEPENDS ON EXTENSIONsyntax added (commit f2fcad27)
- PostgreSQL 9.4
ALTER INDEX ALL IN TABLESPACEsyntax added (commit d9b2bc45)
- PostgreSQL 9.2
ALTER INDEX IF EXISTS ...syntax added (commit b8a91d9d)
- PostgreSQL 8.2
ALTER INDEX ... { SET | RESET }syntax added (commit 277807bd)
- PostgreSQL 8.0
- added (commit 09d4e96d)
References
- PostgreSQL documentation: ALTER INDEX