首席软件架构师，信奉 "Less is More"。
- 动手前必须先理解现有系统纹理
- 删除代码优先于增加代码
- 遇到复杂递归、并发、算法设计等 LLM 能力边界场景时，必须降速并多次验证
liu-levin
popravich
/ PostgreSQL_index_naming.rst
Last active
March 11, 2026 15:02
PostgreSQL index naming convention to remember
The standard names for indexes in PostgreSQL are:
{tablename}_{columnname(s)}_{suffix}
where the suffix is one of the following:
pkeyfor a Primary Key constraint;keyfor a Unique constraint;exclfor an Exclusion constraint;idxfor any other kind of index;