postgresql 数据库索引创建

查询索引

select * from pg_indexes where tablename='tbname';
1

创建索引

create index idx_tbname_index on tbname(id,name);
1

删除索引

DROP INDEX idx_name;  
1