The standard names for indexes in PostgreSQL are:
{tablename}_{columnname(s)}_{suffix}
where the suffix is one of the following:
pkey
for a Primary Key constraint;uq
for a Unique constraint;excl
for an Exclusion constraint;idx
for any other kind of index;