PostgreSQL default suffixes

Last modified: 20/12/2022

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