I am using openshift env and postgres 15.2. I can see cron job for pgbackrest already. Similarly I want to execute certain postgres functions periodically. Creating table was asked as example..
I am using postgres 15.2 version. I want to write a yaml code to run a cron job that creates a table emp(I'd int) every 5mns
This makes no sense…
YAML is markup, it doesn’t run anything. Something has to interpret the YAML.
I also can’t imagine how creating a fixed table periodically is useful; seems like it should fail every time but the first. What problem is this supposed to solve?
Anyway, cron itself runs periodically - you don’t run it. Just have it execute a psql command or bash script that includes using psql.