PostgreSQL 查看表的索引 见代码如下
SELECT tablename,
indexname,
indexdef
FROM
pg_indexes
WHERE
tablename in( 'bitem')
ORDER BY
tablename,
indexname;
SELECT tablename,
indexname,
indexdef
FROM
pg_indexes
WHERE
tablename in( 'bitem')
ORDER BY
tablename,
indexname;