CODE EXAMPLE FOR SQL

naming conventions postgres index

The standard names for indexes in PostgreSQL are:
{tablename}_{columnname(s)}_{suffix}