Insert data using cron and trigger pg_net
I am trying to setup a cron to make an http request every 5 min and then use the resulting json to insert data in a table.
I am able to schedule the http call using pg_cron, but I can't seem to create a trigger on the net database to watch the _http_response table.
Is there something I am missing or that I should do differently?
I am able to schedule the http call using pg_cron, but I can't seem to create a trigger on the net database to watch the _http_response table.
Is there something I am missing or that I should do differently?
