Contents
ALTER INDEX
An SQL 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 EXTENSION
syntax added (commit 5fc70394)
- PostgreSQL 11
- PostgreSQL 9.6
DEPENDS ON EXTENSION
syntax added (commit f2fcad27)
- PostgreSQL 9.4
ALTER INDEX ALL IN TABLESPACE
syntax 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)
Examples
Basic usage example for ALTER INDEX
:
postgres=# ALTER INDEX foo_bar_id_idx RENAME TO foo_bar_ref_idx; ALTER INDEX
References
- PostgreSQL documentation: ALTER INDEX