How to create scheduled jobs in PostgreSQL?
PostgreSQL doesn't have the concept of scheduled jobs.
You can use
With these, just use
psql to connect the db and feed it a sql file.
psql -d myDb -f "mySQL.sql"
If you want an EXTENSION that does some of this, you can check out pg_cron.
You can configure your recurring tasks by creating database jobs in PostgreSQL. PostgreSQL provides one external tool to configure PostgreSQL jobs, its name is
PGAgent (a part of pgAdminIII) is an external tool by the Postgres community which is used to create and manage database jobs.
For your further reference: How to create job in PostgreSQL