PostgreSQL 查看表的索引

  PostgreSQL 查看表的索引 见代码如下

SELECT tablename,
    indexname,
    indexdef
FROM
    pg_indexes
WHERE
    tablename in( 'bitem')
ORDER BY
    tablename,
    indexname;

结果：