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

Popular posts from this blog

c# - Operator '==' incompatible with operand types 'Guid' and 'Guid' using DynamicExpression.ParseLambda<T, bool> -