Table "public.member" で、DROP INDEX

examdb=# \d member;
                  Table "public.member"
 Column |     Type      | Collation | Nullable | Default 
--------+---------------+-----------+----------+---------
 id     | integer       |           |          | 
 name   | text          |           |          | 
 tel    | character(11) |           |          | 
Indexes:
    "member_idx" btree (id, name, tel)

examdb=# DROP INDEX member_idx;
DROP INDEX

examdb=# \d member;
                  Table "public.member"
 Column |     Type      | Collation | Nullable | Default 
--------+---------------+-----------+----------+---------
 id     | integer       |           |          | 
 name   | text          |           |          | 
 tel    | character(11) |           |          |