you need to know the name of the index
and then write
drop index indexname
if you are using phpPgAdmin there will be a link to the list of all indexes
otherwise in the console
type \?
this will list all the options for lists
e.g. \df gives a list of functions and so on
choose the command to list indexes and then
type
drop index indexname
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.