Merlin Moncure wrote: > looks much better than OrgID. I suggest not prefixing tables with > 'tbl', but idx_ for indexes and fk_ for foreign keys is ok. I've recently gotten into the habit of naming my indexes after exactly what they index. For example: create index "foo(x,y,z)" on foo(x,y,z); and CREATE INDEX "tbl using gist(text_search_vec)" on tbl using gist(text_search_vec); It's just as obvious as prefixing them with "idx_" and makes EXPLAIN output a bit quicker for me to understand.
