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
- ALTER INDEX ... ATTACH PARTITION ... syntax added (commit 8b08f7d4)
- ALTER INDEX ... ALTER COLUMN ... SET STATISTICS syntax added (commit 5b6d13ee)
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.1
- ALTER INDEX ... OWNER syntax now ignored and generates a WARNING (commit 83357da6)
PostgreSQL 8.0
- added (commit 09d4e96d)

Basic usage example for ALTER INDEX:

postgres=# ALTER INDEX foo_bar_id_idx RENAME TO foo_bar_ref_idx;
ALTER INDEX