# Postres Naming Conventions ## Indexes The standard names for indexes in PostgreSQL are: > `{tablename}_{columnname(s)}_{suffix}` | Suffix | Meaning | | ------- | ------------------- | | `pkey` | Primary Key | | `key` | Unique key | | `excl` | Exclusion contraint | | `fkey` | Foreign key | | `check` | Check contraint | | `idx` | All other index types | ## Sequences Standard suffix for sequences is * `seq` for all sequences #postgres