I know how to make a primary key within a table, but how do I make an existing index a primary key? I'm trying to copy an existing table from one database to another. When I show the table, the index at the bottom is in this form:
"my_index" PRIMARY KEY, btree (column1, column2)
I have created the index with:
CREATE INDEX my_index ON my_table (column1, column2)
But I do not know how to make it the primary key ...
UPDATE: The version of my server is 8.3.3