I know how to find index by name in MS SQL Server just by search for %name%
But where I can do the same in PGAdmin4 ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
As a horse_with_no_name provided, you can search the
pg_indexes meta-table to find an index by name with the query:
SELECT * FROM pg_indexes WHERE indexname LIKE '%NameOfIndexYoureSearchingFor%';
Regarding your second question in the comments on how to delete an index in PostgreSQL, you can script it out with a query like this:
DROP INDEX NameOfIndexYouWantToDrop;
PostgreSQL documentation on
DROP INDEX for more information.