Postgresql index naming convention

Use the table name as the prefix.

Use the following suffixes:
_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

https://stackoverflow.com/a/4108266/801426
Also implicitly mentioned here — https://www.postgresql.org/docs/current/sql-altertable.html

Similar Posts

LEAVE A COMMENT