postgresql 数据库索引创建

查询索引

select * from pg_indexes where tablename='tbname';

创建索引

create index idx_tbname_index on tbname(id,name);

删除索引

DROP INDEX idx_name;