Hi Guys, sorry for my late answer. I tested this today and working like a charm!
You are brilliant ! thank you, saved my ass! Best, Jacek śr., 11 lip 2018 o 10:30 Ken Tanzer <ken.tan...@gmail.com> napisał(a): > > > On Tue, Jul 10, 2018 at 5:45 PM Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> select add_trigger('trg_test'); >> >> test=> \d trg_test >> >> Table "public.trg_test" >> >> >> Column | Type | Collation | Nullable | Default >> >> >> --------+-------------------+-----------+----------+--------- >> >> >> id | integer | | | >> >> >> fld_1 | character varying | | | >> >> >> Triggers: >> >> >> trg_test_change AFTER UPDATE ON trg_test FOR EACH STATEMENT EXECUTE >> PROCEDURE ts_update() >> >> > To take this a step further, if you really have a lot of tables and want > to do it automatically, you could do something like this: > > SELECT table_name,add_trigger(table_name) FROM information_schema.tables > WHERE table_schema='public'; > > This assumes that you want to add the trigger to _all_ your tables, and > that you haven't made use of schemas and so your tables are all in the > public schema. > If that's not the case, you could adjust accordingly. It would be safest > to just pull the table names first, make sure the list is what you want, > and then run with the add_trigger. So start with this: > > SELECT table_name FROM information_schema.tables WHERE table_schema='public'; > > and if the list of tables is what you want, then run with the add_trigger > included. > > Cheers, > Ken > > > -- > AGENCY Software > A Free Software data system > By and for non-profits > *http://agency-software.org/ <http://agency-software.org/>* > *https://demo.agency-software.org/client > <https://demo.agency-software.org/client>* > ken.tan...@agency-software.org > (253) 245-3801 > > Subscribe to the mailing list > <agency-general-requ...@lists.sourceforge.net?body=subscribe> to > learn more about AGENCY or > follow the discussion. >