In postgres how do I add index to existing table?

Question

In postgres how do I add index to existing table?

I tried following but it's not working:

CREATE INDEX my_index ON my_table USING btree(a_column);

and then this:

CREATE INDEX my_index ON my_table USING btree(a_column);

But neither works.

I am using ant to do a db migration. And when I do ant db-migrate-apply-postgresql I keep getting the error

 [echo] ERROR:  relation "my_index" already exists

Answer 1

Well, this error message:

ERROR: relation "my_index" already exists

is pretty clear, isn't it.

You are trying to create an index with the name of an existing index or table. You need to use a different name.