Getting the indexes of a table

["Christian Hofmann" <christian(dot)hofmann(at)gmx(dot)de>]

Hello,

I want to get the indexes that are installed in one table.
I looked at the information_schema but there was nothing to use.

I am looking for something like

SELECT column_name, index_name FROM ... WHERE table_name = 'abc'

How should my query look?

Thank you,

Christian