Example
The following example drops an index called customer_id_idx from the booktown database:
booktown=# DROP INDEX customer_id_idx;
DROP
The next example drops two indices simultaneously from the booktown database:
booktown=# DROP INDEX books_id_pkey, books_title_idx;
DROP