PostgreSQL default suffixes

The standard names for indexes in PostgreSQL are

{tablename}_{columnnames}_{suffix}

where the suffix is one of the following:

• pkey for a Primary Key constraint
• key for a Unique constraint
• excl for an Exclusion constraint
• idx for any other kind of index
• fkey for a Foreign key
• check for a Check constraint
• seq for all sequences