Converting mySQL's KEY to PgSQL?

Question

I'm converting some mySQL code to pgSQL and I've run into this problem

mysql code : "KEY ug_main_grp_id (ug_main_grp_id)"

What would be the equivalent in PgSQL. First I thought I could just use CREATE INDEX in pgSQL, but that's really not appropriate because KEY is not an index :P

Answer 1

KEY is an index, if that's the exact syntax you're porting.

Answer 2

PRIMARY KEY (ug_main_grp_id)

Answer 3

If they key is unique, just use UNIQUE as in:

mycolumn int NOT NULL UNIQUE

but if it's a non-unique one, you need to use the CREATE INDEX command.