postgresql - See all indexes and appropriate columns for table -


how see existed indexes table? example given table mytable, how see every index appropriate columns?

try sql

select * pg_indexes tablename = 'mytable'; 

Comments