EN
PostgreSQL - remove index from existing table
3 points
In this article, we would like to show you how to remove an index from the existing table in PostgreSQL.
Quick solution:
xxxxxxxxxx1
ALTER TABLE "table_name"2
DROP INDEX "index_name";or
xxxxxxxxxx1
DROP INDEX "index_name" ON "table_name";In this example, we will remove the salary_index created in the previous article.
Query:
xxxxxxxxxx1
ALTER TABLE "users"2
DROP INDEX "salary_index";or
xxxxxxxxxx1
DROP INDEX "salary_index" ON "users";