The standard names for indexes in PostgreSQL are
{tablename}_{columnnames}_{suffix}where the suffix is one of the following:
pkey for a Primary Key constraintkey for a Unique constraintexcl for an Exclusion constraintidx for any other kind of indexfkey for a Foreign keycheck for a Check constraintseq for all sequences