January 2002
Intermediate to advanced
640 pages
16h 39m
English
Content preview from Practical PostgreSQLBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Drop Index
Removes an index from a database.
Synopsis
DROP INDEX index_name [, ...]Parameters
index_nameThe name of the index you wish to remove from the database.
Results
DROPThe message returned if the index is removed successfully.
ERROR: index "index_name" does not existThe error returned if the specified index cannot be found within the database.
Description
The owner of an index may remove it from the database by using this command.
Example
The following example drops an index called customer_id_idx from the
booktown database:
booktown=# DROP INDEX customer_id_idx;
DROPThe next example drops two indices simultaneously from the booktown
database:
booktown=# DROP INDEX books_id_pkey, books_title_idx;
DROP