Search Postgresql Archives

Re: Create event triger

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Tue, Jul 10, 2018 at 5:45 PM Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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
(253) 245-3801

learn more about AGENCY or
follow the discussion.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux