postgres naming trigger
Last updated
Was this helpful?
Last updated
Was this helpful?
Taken From
Pattern [TBALE_NAME]_[FUNCITON NAME]_[WHEN][1 or more WHY][t]
When:
b - Before
a - After
i - Instead of
WHY:
i - Insert
u - Update
d - Delete
t - Truncate
t = 'trigger'
eg: my_table_update_ts_biut
means it's a trigger on my_table, triggers update_ts before insert & update
Reasoning: Just by looking at the trigger name, you know which table, and when it is triggered
example