-1

How to set any postgres function in crontab with frequency of seconds? Thank you in advance.

Tried searching for seconds timer scheduling. But looks like postgres / crontab doesn't support for seconds setup. only minute, hour, day, etc options are available. Looking for any alternative option.

Prachita Raut
  • 1
  • 1
  • 1

1 Answers1

0

If your PostgreSQL version is 10+ then you can use pg_cron extension to schedule scripts directly from the database.

As stated in the documentation,

... You can also use '[1-59] seconds' to schedule a job based on an interval.

Albina
  • 1,901
  • 3
  • 7
  • 19