查询某个标下的索引:
select * from pg_indexes where tablename='ls_trs_tunnel_route';
查询数据库中全部索引:
SELECT tablename, indexname, indexdef
FROM pg_indexes
WHERE schemaname = 'public';
查询某个标下的索引:
select * from pg_indexes where tablename='ls_trs_tunnel_route';
查询数据库中全部索引:
SELECT tablename, indexname, indexdef
FROM pg_indexes
WHERE schemaname = 'public';