This seems like such a simple question that I feel I have to be overlooking something, but alas here I am since I couldn't find someone else asking this on the internet...
How do you view a list of indexes in pgAdmin?
I know I can select a table, and then view that tables indexes... But what I want (and I guess what I'm used to coming from the world of Oracle and TOAD) is to be able to quickly view ALL my indexes. (I know I can write an SQL, but doesn't that defeat the purpose of a GUI?)
List Indexes using pg_indexes view. (from google):
The pg_indexes view allows you to access useful information on each index in the PostgreSQL database. The pg_indexes view consists of five columns: schemaname: stores the name of the schema that contains tables and indexes.
For me a UI does not replace SQL-statements. I am working with SQL Management Studio and Oracle Enterprise Manager in my company and there are a lot of information I use SQL queries for. From my perspective the UI supports you in doing the most common tasks, and you can surely do a lot more of stuff on DB level.