How to name indexes in PostgreSQL?

Question

PostgreSQL

What are the rules for indexes? I create, for example, uniqName for the Users table. Then I try to create a uniqName for Themes (let's say blog topics). I get an error saying the index already exists. So what is the best way to name indexes? And wouldn't a big name like themes_uniq_name, users_uniq_name or compound users_uniq_name_user_id (something like that) be a brake?

Answer 1

www.stackoverflow.com/a/4108266