SHOW INDEX FROM yourtable;
SHOW INDEXES FROM table_name;
SELECT tablename, indexname, indexdef FROM pg_indexes WHERE schemaname = 'yourschema' and tablename='yourtable' ORDER BY tablename, indexname; (POSTRGRESQL)
