May 2018
Intermediate to advanced
576 pages
30h 25m
English
The standard names for indexes in PostgreSQL are as follows:
{tablename}_{columnname(s)}_{suffix}
Here, the suffix is one of the following:
The standard suffix for all sequences is seq.
Tables can have multiple triggers fired on each event. Triggers are executed in alphabetical order, so trigger names should have some kind of action name to differentiate them and to allow the order to be specified. It might seem a good idea to put INSERT, UPDATE, or DELETE in the trigger name, but that can get confusing if you have triggers that work on both ...