List table indexes

gistfile1.sql

SELECT
    s.index_name AS name,
    s.column_name,
    s.non_unique AS `unique`,
    c.constraint_type
FROM information_schema.statistics s
LEFT JOIN information_schema.table_constraints c
ON (
    s.index_name = c.constraint_name
)
WHERE s.table_schema = 'uriae'
AND (
    c.constraint_type NOT IN ('PRIMARY KEY', 'FOREIGN KEY') 
    OR c.constraint_type IS NULL
)