SELECT * FROM pg_indexes WHERE tablename = 'your_table';

или

SELECT indexname, indexdef FROM pg_indexes WHERE tablename = 'your_table';