1SHOW INDEX FROM yourtable;
1SHOW INDEXES FROM table_name;
1SELECT
2 tablename,
3 indexname,
4 indexdef
5FROM
6 pg_indexes
7WHERE
8 schemaname = 'yourschema' and tablename='yourtable'
9ORDER BY
10 tablename,
11 indexname;
12(POSTRGRESQL)