如何使用golang捕获新的postgreSQL记录的事件

Question

I have a script that connects to DB and can get data from it Can I somehow make it to notify me, when any new record is added to the DB table

Answer 1

Thank everyone for the answers

Solved this using sql triggers and go-pg library:

1. Created sql function called insert_test_func, that on INSERT(in my case) action do

            PERFORM pg_notify('mychan', 'Message');
   

2. Created trigger, that executes func

   create trigger check_insert 
   before insert or update on *my_table_name*
   for each row 
   execute procedure insert_test_func();
   

   And execute this trigger

3. With "github.com/go-pg/pg", connect to the DB and with pg.Listen(function ) listening to the channel for the 'Message'