Please add the "search_path", it is very useful.

[6LWa6ZKx]

LOG_FILENAME="$(date '+%Y%m%d_%H%M%S')"
pgagent -l 2 -s "/var/lib/postgresql/${LOG_FILENAME}.log" dbname=digital user=platform search_path='xx,public' hostaddr=127.0.0.1

We can add an additional parameter, or a URL parameter, for example: search_path='xx,public'. This is very useful when calling some nested stored procedures, functions, or certain irregular statements that are forgotten.

27/5000
Finally, we would like to express our gratitude for your efforts. This GUI is very user-friendly and is superior to cron.