Listing indices using sqlalchemy

Question

Is it possible to list all indices in a db using sqlalchemy?

Answer 1

A little update to @nosklo's answer which is deprecated since SQLAlchemy 1.4.

New code should be:

from sqlalchemy import create_engine, inspect

engine = create_engine("...")
insp = inspect(engine)
for name in insp.get_table_names():
    for index in insp.get_indexes(name):
        print(index)

Note you can also use a Connection object as argument to inspect - can be more convenient in some cases.

Answer 2

yes.

from sqlalchemy import create_engine
from sqlalchemy.engine import reflection
engine = create_engine('...')
insp = reflection.Inspector.from_engine(engine)
for name in insp.get_table_names():
    for index in insp.get_indexes(name):
        print index