Triggers

Hi list,

 

I am planning to generate a trigger to each [update or delete or insert] on my database to register all moviment on my base (current_user, when, action, user).

 

I notice that the trigger is able put a procedure in action but as I have more than 20 tables I would like to use only one trigger to solve my problem. Is that possible ?

 

Now my trigger is working well but I do not want to make 26 triggers and 26 functions.

 

Is there any people that can help me with this question ?


=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
                                  Atenciosamente (Sincerely)
                        Ezequias Rodrigues da Rocha
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
A pior das democracias ainda é melhor do que a melhor das ditaduras
The worst of democracies is still better than the better of dictatorships
http://ezequiasrocha.blogspot.com/