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

Examples

Basic usage example for ALTER INDEX:

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

Categories

DDL, Indexing, SQL command

See also

CREATE INDEX, DROP INDEX