pgadmin see indexes 1

pgadmin see indexes

select *
from pg_indexes
where tablename not like 'pg%';

Here is what the above code is Doing:
1. We’re selecting all the columns from the pg_indexes table.
2. We’re filtering out all the tables that start with pg.

Now, let’s run the query:

Similar Posts