0

Context : I am keeping one counter table to store max counters of all the tables in the public schema. (Which are updating automatically with trigger or functions upon updating main table) But if someone created a new table in DB and forgot to add an entry in counter table, then mismatch occurring.

I need to overcome this problem. Is there any library or way to add newly created table automatically?

Research : I have gone through this one : Is there any way to automatically create a trigger on creation of new table in MySQL? But haven't found anything useful.

I am thinking of creating trigger, like after performing any inset in information_schema.tables, will copy that table name and store in counter table with 0 as counter value

~Soham

SOHAM N.
  • 110
  • 8
  • 2
    You can use an [event trigger](https://www.postgresql.org/docs/current/plpgsql-trigger.html#PLPGSQL-EVENT-TRIGGER) (which could also handle dropping of tables), see e.g. [here](https://stackoverflow.com/questions/39936923/get-created-table-name) –  Sep 23 '20 at 07:27
  • Ok, wait will try and update to you! :thumbsup: – SOHAM N. Sep 23 '20 at 07:40

0 Answers0